Protecting a Worksheet Question
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 *** |
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 *** |
All times are GMT +1. The time now is 10:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com