Setting Protection on Workbook to be read only

[bamaisgreat]

Thanks for the veiw.

I have a Workbook named "Master Archive" that contain data from 9 workbooks. This is all done with a macro upon opening each workbook and using a command button to send the data to it. Question is I want everyone to be able to view the Master Archive Workbook in a readonly fashion and the orginal to always remain closed. Reason being is I cant run the macro to archive the data if someone has it open, which then would cause debug issues with the code. Are there settings were I can be the only one to open the workbook and be able to Edit.
Also Everyone has a shortcut to this Master Archive on there Destop.

 

[hippiehacker]

have a look here VBA Express : Excel - Force users to enable macros in a workbook I've implemented this for some workbooks where macros needs to be enabled