Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Event on Dropbox
I have a drop box that has a change event. The Change event causes the linked
cell on a different worksheet to change. I want to lock down (protect) the worksheet where the linked cell is located. When protect the worksheet where the linked cell is located I get an error stated that the field can't be updated... Makes sense, so I unprotected that cell on the protected sheet.... didn't help. I was looking for an event, (like on activate) for the dropbox to run the macro to Unlock this worksheet. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Event on Dropbox
sub dropbox_change()
ActiveSheet.unProtect 'insert whatever in the other sheet ActiveSheet.protect end sub Troubled User wrote: I have a drop box that has a change event. The Change event causes the linked cell on a different worksheet to change. I want to lock down (protect) the worksheet where the linked cell is located. When protect the worksheet where the linked cell is located I get an error stated that the field can't be updated... Makes sense, so I unprotected that cell on the protected sheet.... didn't help. I was looking for an event, (like on activate) for the dropbox to run the macro to Unlock this worksheet. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i make a dropbox? | Excel Discussion (Misc queries) | |||
how to get a 2nd dropbox based on results, entry of 1st dropbox | Excel Discussion (Misc queries) | |||
MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
Excel Dropbox Help | Excel Programming | |||
Dropbox Question: | Excel Programming |