View Single Post
 
Old 11-18-2016, 07:41 AM
ernief ernief is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Nov 2016
Posts: 5
ernief is on a distinguished road
Default 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
Reply With Quote