Using "protection" as a macro condition
Is there a way to refer to "protection" (its on/off condition), in a Macro
line?
A simple example would be -
If "protection is off" Then Worksheets("abc").Range("a5").Value = 0
I need to know the coding to use that would replace "protection is off" in
the above line. It could also be connected to whether or not there is a
password present.
I hope this can be done.
Ed
|