Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!!!! :) |
#2
|
|||
|
|||
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!!!! :) |
#3
|
|||
|
|||
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!!!! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
protecting shared workbook | Excel Discussion (Misc queries) | |||
Protecting Workbook | Excel Discussion (Misc queries) | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |