Unprotecting sheet in a macro
Hi
I have successfully unprotected a sheet for sorting and then protected it again at the end of a macro button, but if there is a password on the protection it asks for that password before continuing. I do not want to give the password to other users. Can I program the password into the macro.
Thanks
Ernie
|