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 ***

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 ***