Volitle

[bw]

If someone Protects or Unprotects a worksheet, how does one "capture"
that fact so that I will know when to cause a manual Calculation?

--

 

[Guest]

How about:

Sub bw()
Dim b As Boolean
b = ActiveSheet.ProtectContents
MsgBox (b)
If b Then
'do something
Else
'do something else
End If
End Sub

 

[bw]

I think you may be missing my point here. If you Protect or Unprotect
the worksheet (not using code), how will I know that you have done that?

 

[Guest]

The point is:

Suppose that I have arbitrarily protected or unprotected any worksheet
(either manually or via VBA) and then gave the worksheet to you. By running
the sub, you (or VBA) can detect what I have done.

 

[Dave Peterson]

There's no event that will fire when the user changes protection. The best you
can do is check it later--maybe with a _selectionchange event???

 

[bw]

Thanks Dave,

There's no event that will fire when the user changes protection.

I suspected that what you said was true. Unfortunate...