Workbook Password protection, but viewing and sorting allowed

[carlajp1]

I am very new to building macros for Excel. I have already password protected my workbook, but I want to be able to allow users to still view the information, sort, etc, but not allow them to save. In other words, the document can be opened with or without a password, but changes will only be allowed if the password was entered.

[Mumps1]

Place the following code in the code module for ThisWorkbook (not into a regular module). Change "password" to whatever password you want to use. Keep in mind that anyone who knows how to access the macros will be ale to see your password. To avoid this, you would have to protect your macros with a password as well. If you are unsure of how to do this, please let me know. Try it out and see if does what you want.

Please Login or Register  to view this content.