View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rowan Drummond[_3_] Rowan Drummond[_3_] is offline
external usenet poster
 
Posts: 414
Default Buttons and Sheet Protection?

I don't think that protecting the sheet will stop the button from being
clicked but it may prevent the associated event from performing some
actions. What is the event code doing?

Regards
Rowan

G Lykos wrote:
Greetings! Have a worksheet with a button and event code. When the sheet
is unprotected, the button and code work fine. When the sheet is protected,
and some cells are selected to be locked but the one with the button is not,
the button doesn't work. There is a host of options for sheet protection,
allowing the user to change this, that, and the other while the sheet is
protected, but none of them seem directly related to this. What would be
interfering with button operation, and/or how can it be enabled on the
protected sheet?

Thanks,
George