|A "program" does not use a macro. |
Do you mean that users can't use the workbook without using the macro?
You still haven't provided enough details for us to offer any suggestions. All you have provided is one line from a macro.
In fact, the first line of your original post doesn't make sense.
My macro won't save properly and is coming up read only.
Macros can't come up read only. A workbook could come up read only, but, as I said earlier, a macro is a script that's is stored in an Excel workbook. "Read only" is not a attribute of a macro, it is an attribute of a file, and that file could be a workbook.
My concern with multiple, individual workbooks is that they can't be easily consolidated if multiple users are making changes to the same cells at (more or less) the same time. For example, if User A opens his copy, changes A1 and saves his copy, then User B opens her copy, changes A1 and saves her copy, how do you "consolidate" those workbooks? As AlteK, said, this are just assumptions. We don't even know if what I just described in an issue or not.
You really need to tell us how your users use the workbook, how changes are made, what needs to be consolidated, etc. We can't help you unless you give us some specifics.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.