Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Lauren
 
Posts: n/a
Default 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   Report Post  
bj
 
Posts: n/a
Default

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   Report Post  
GaryO44
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? Bill O'Neal Excel Worksheet Functions 8 August 14th 09 11:36 PM
protecting shared workbook G Excel Discussion (Misc queries) 2 June 9th 06 04:37 PM
Protecting Workbook Paul Cooling Excel Discussion (Misc queries) 2 March 7th 05 11:55 AM
Unprotect Workbook Kent Excel Discussion (Misc queries) 1 February 4th 05 01:07 AM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 02:02 PM


All times are GMT +1. The time now is 08:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"