button in a protected sheet
 

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.

button in a protected sheet
 

what does the the macro the button calls do??
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.

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.