Lock saved worksheet

[KLahvic]

I have code written to auto save the active worksheet when a button on my user form is pressed. What I would like to know is if there is a way to lock the worksheet when the button that triggers the save event is pressed behind the scenes so the end user has a more difficult time editing the sheet. I know they can just resave the document and the protection will be gone, but for minimizing user manipulation please let me know.

Ken

By the way, to all of you who have helped me on this project so far, I can't tell you how greatful I am to be in the company of such programming expertise. THANK YOU!

[teshiburu1988]

you could use a code like

Please Login or Register  to view this content.

and you can put a password in the brackets... dont know if this will be of any help, sorry i cant post more for some reason this site times out if i try to do more in depth responses!

[KLahvic]

Works perfectly, just had to play with the placement of the code. Thank you very much, you have been added to the list of rock stars who had their hand in the development of this tool.

Ken