How to detect protected sheet
Do it the type of item being protected:
Sub dural()
Dim s As Worksheet
Dim t As Boolean
Set s = ActiveSheet
t = s.ProtectContents
MsgBox (t)
End Sub
--
Gary''s Student - gsnu200905
"IanC" wrote:
How do I detect whther a sheet is protected or not? I need the sheet
unprotected for the subroutine, but I need to know whether it was already
unprotected so I can leave it in the same satte after the sub runs.
--
Ian
--
|