View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Protecting a Worksheet Question

Hi Les,

I would have thought that would be pretty easy work out if events still fire
if the sheet is protected simply by trying. But yes, events work in the
normal way when a sheet is protected, though of course it may not be
possible to perform certain actions on the protected sheet.

Regards,
Peter T

"Les Stout" wrote in message
...
Hi all, if a worksheet is protected do all the functions, e.g.
"beforeRightClick", "Change" etc... still work ? or must one unprotect
with code first for it to work ?

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***