Hello - Hopefully someone can offer a suggestion to this problem I have.
I currently have VBA code that opens a master workbook and then updates 20 departmental workbooks with data from the master. The departmental workbooks are read-only as I don't want my users to change them.
I remove the read-only attribute in my program so I can save the workbook once I've got it open in my program. Problem is, if one of the users is viewing the workbook, my program cannot access it to update it.
Is there a way to way I can keep the departmental workbooks read-only so the users can't change them, but my VBA program can open save them - even if they are being viewed at the time the program runs? I read about shared workbooks, but I don't think this is what I want. I admit I don't know that much about the intricacies of Excel...
Thanks,
Marcie
I currently have VBA code that opens a master workbook and then updates 20 departmental workbooks with data from the master. The departmental workbooks are read-only as I don't want my users to change them.
I remove the read-only attribute in my program so I can save the workbook once I've got it open in my program. Problem is, if one of the users is viewing the workbook, my program cannot access it to update it.
Is there a way to way I can keep the departmental workbooks read-only so the users can't change them, but my VBA program can open save them - even if they are being viewed at the time the program runs? I read about shared workbooks, but I don't think this is what I want. I admit I don't know that much about the intricacies of Excel...
Thanks,
Marcie