Thread: Locked cells and makro not working?

Hello

What I'm trying to do is lock a few cells and secure the sheet with a password. But when I do and if I try to run the makro I get an error becose the makro could not copy the text from the UserForm to the sheet. Is it possible to make the makro work and still keep the cells locked so other users can't change the cells value later?

Hi,

You can removed the password protection at the beggining of the Macro and again apply it at the end.

ActiveSheet.Unprotect Password:="yourpassword"

at the end --->
ActiveSheet.Protect Password:="youdontknow"

hope it works for u