Protecting a Worksheet Question

L

Les Stout

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

Peter T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top