Does anybody know how to find if an Excel worksheet is protected?
For example
If (sheet1 is protected) Then
MsgBox("Protected")
Else
MsgBox("Not Protected")
End If
I used .protect = true but this property actually protects
the sheet rather than return a value
Any ideas?




Reply With Quote