Protecting A Workbook from being saved/written over

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!! :)
 
Save the document as read only. Then they have to know what they are doing
before they can save over the top of it.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to push data to another workbook 0
Excel workbook will not save 2
Workbook save options 4
Workbook Protection Password Overwritten 2
Password Protecting a workbook 2
saving macro from workbook to Personal Macro Workbook 1
Password Protect so can't save and change 1
Protection 2

Back
Top