Forum Discussion
Solved
Force user to SAVEAS
I have a file to put in a shared folder. It served as a template for others. Other users may open and write the file but I don't want them to save the "template" file. Is there a way to prevent them ...
Hi Man Fai Chan
Good to hear you have some ideas to go forward with.
Out of curiousity, is your network file saved as an Excel Macro-enabled template (*.xltm)?
Cheers
Damien
Mr. Chan
The recommendation of Mr. Rosario is what I have been doing to prevent my templates from being written over.
However, if the user (with bad intention) knows the trick to change it in the file properties - no one can stop that!
Maybe what you are asking is a vba to do that protection. I wonder, if there is...
MVP's.. anyone?
actually, I had been searching the net for forced SAVEAS - but no luck.. still, I think there is a code for that.