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 wrote:

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

--


--

Dave Peterson