View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 279
Default 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