I have a template that everyone at work uses for filling out purchase orders. It has a built in contact list that is opened through a userform and is constantly being updated. The contact list is on say sheet4. Every once in a while users will accidentally fill out information and save over the master file. Is there a way to only allow changes to be made and saved on one worksheet but not save any of the changes on the other?
I think if there is a way to check what the filename is and if it is (for example) template.xlsm then do not allow certain macros or cells to be executed/changed but if they fill out some info and change the filename to (for example) template-0045.xlsm then allow changes.
This would act just like it is read only but a little different I guess.
Any help would be appreciated on this one!