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
Thanks for your thoughts, Lorenzo.
Man Fai Chan would only need to do the VBA route if people are purposefully change the template.
I suspect it's more about users accidently editing it versus purposefully changing it which isn't hard to do.
If it is on purpose then people are being very naughty!
Cheers
Damien
Man Fai Chan would only need to do the VBA route if people are purposefully change the template.
I suspect it's more about users accidently editing it versus purposefully changing it which isn't hard to do.
If it is on purpose then people are being very naughty!
Cheers
Damien
Mr. Rosario,
Thanks for the info. May I request for that VBA - force a SAVEAS.
many many thanks
Thanks for the info. May I request for that VBA - force a SAVEAS.
many many thanks