View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stevebriz stevebriz is offline
external usenet poster
 
Posts: 195
Default 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.