If Sheet Protected Then...
-
-
-
Re: If Sheet Protected Then...
If the worksheet is protected, what would trigger the code?
-
Re: If Sheet Protected Then...
I'm not leaving the code easily accessible, but I'm also not going to great lengths to secure it, either. If an end user somehow finds their way into the macro menu and attempts to run a macro while the worksheet is protected, I'd like that user to get a polite message telling them to buzz off. :p
-
-
Re: If Sheet Protected Then...
The Protection Object has 11 properties that you can test, and ProtectionMode tells you whether the protection is UserInterfaceOnly.
-
-
Re: If Sheet Protected Then...
Thanks very much!
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!