button in a protected sheet
try this
put this at the start of you macro
Worksheets(1).UnProtect ("Pwd")
put this at the end of you macro
Worksheets(1).Protect ("Pwd")
PS you need to change these to use your password and refer to the
correct sheet
Frigster wrote:
Hi,
I have a button in a sheet.
When i protect the sheet the button doesn't work anymore. It could be
pressed but the code doesn't make anything.
In the properties of button I tried to select and deselect the option
"blocked" but... no way.
Where am I going wrong?
Thanks a lot.
Paolo.
|