Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Allow custom update button to work while sheet is protected | Excel Discussion (Misc queries) | |||
use macro button to run macro in protected sheet | Excel Discussion (Misc queries) | |||
radio button on protected worksheet | Excel Programming | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
Command Button not working once sheet is protected | Excel Programming |