Forum Discussion
Protecting an Excel workbook
I am using Excel 97-2003 and thus far have been able to protect (Encrypt with password) a workbook with a password, but this option only gives me access to the document.
I need to protect the document with a password to prevent accidental changes from other viewers, but need to provide them with a read only option.
3 Replies
Ruben2011 In Excel under the REVIEW tab you can find 'Protect Sheet' and 'Protect Workbook' which may help or under Save As there is a 'More Options ...' that pops up a Save As box and then to the left of the Save button there is a Tools drop down and select General Options. In that popup box there are options to add a PW to open and a PW to modify. If you only add PW to modify then anyone can open but not make changes.
As Mr. mtarler already informed you, you can do this with the command "Protect workbook". But with Excel you have several possibilities to accomplish something, depending on your needs and knowledge. One of these possibilities is also VBA. Here is additional information about what Mr. mtarler has already described and with VBA macro as an example.
Protect a worksheet
Protect a workbook
Sub protection ()
ActiveSheet.Protect Password: = "Password Name", UserInterfaceOnly: = True, DrawingObjects: = True, Contents: = True, Scenarios: = True
End Sub
Sub unprotection ()
ActiveSheet.Unprotect Password: = "Password Name"
End Sub
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
