ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protecting A Workbook from being saved/written over (https://www.excelbanter.com/excel-discussion-misc-queries/32658-protecting-workbook-being-saved-written-over.html)

Lauren

Protecting A Workbook from being saved/written over
 
Anyone know how to protect the workbook from someone SAVING changes they may
have made? The workbook needs to be accessible for others to run various
scenarios, but should not be saved over the "original" generated by
myself...Anyway to do this without getting IT involved?

ANY suggestions would be much appreciated!!!! :)

bj

Save the document as read only. Then they have to know what they are doing
before they can save over the top of it.

"Lauren" wrote:

Anyone know how to protect the workbook from someone SAVING changes they may
have made? The workbook needs to be accessible for others to run various
scenarios, but should not be saved over the "original" generated by
myself...Anyway to do this without getting IT involved?

ANY suggestions would be much appreciated!!!! :)


GaryO44

More details on the suggested solution:
When you do the Save As the window has a Tools pull-down menu on the menu
bar for that window. Select the general options option. Set a password and
click the "Read Only" check box. When someone opens the sheet they will get a
window for a password or they can open "read only". Once open they can save
it anywhere they want but NOT overtop the original.



"bj" wrote:

Save the document as read only. Then they have to know what they are doing
before they can save over the top of it.

"Lauren" wrote:

Anyone know how to protect the workbook from someone SAVING changes they may
have made? The workbook needs to be accessible for others to run various
scenarios, but should not be saved over the "original" generated by
myself...Anyway to do this without getting IT involved?

ANY suggestions would be much appreciated!!!! :)



All times are GMT +1. The time now is 05:23 PM.

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