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.

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.