View Single Post
  #2   Report Post  
Michael
 
Posts: n/a
Default

'Cause when you save the protected workbook, it also saves the protection.
Even when it is renamed, the protection remains.
--
Michael Mitchelson


"JSP" wrote:

When I protect a workbook so that users cannot modify it without knowing the
password, what prevents the user from doing the following:
1. Open the workbook in read-only mode (I do want others to be able to read
the workbook).
2. Select save as and give the file a new name.
3. Delete the original (password protected) workbook.
4. Rename the new (unprotected workbook) to the name of the original
workbook.
5. Edit the workbook and then save the changes.