ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protection or some other method used to person must "save as" (https://www.excelbanter.com/excel-discussion-misc-queries/49191-protection-some-other-method-used-person-must-%22save-%22.html)

[email protected]

Protection or some other method used to person must "save as"
 
I want the person I making a template for to have to do a save as and save
it as another spreadsheet each time and not be able to change the original.
Is that "protection", or some other method is used?

Thanks

Dave Peterson

I find the simplest thing to do is to mark the file as readonly in windows
explorer (well, if the file is in a common folder for everyone).



omnetws wrote:

I want the person I making a template for to have to do a save as and save
it as another spreadsheet each time and not be able to change the original.
Is that "protection", or some other method is used?

Thanks


--

Dave Peterson

[email protected]

Ahhh! that maybe what I was trying to think of. If I make it "read-only",
and put on his computer he will have to "save-as" and make another copy each
time? Uhhh, my memory sucks now :O/

Thanks!!!!!

Dave Peterson

There are other options, too.

You could save your workbook as a template, then have the users create a new
workbook based on that template.


omnetws wrote:

Ahhh! that maybe what I was trying to think of. If I make it "read-only",
and put on his computer he will have to "save-as" and make another copy each
time? Uhhh, my memory sucks now :O/

Thanks!!!!!


--

Dave Peterson


All times are GMT +1. The time now is 09:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com