MrExcel.com - Your One Stop for Excel Tips & Solutions

Is the ActiveSheet locked or not?

Posted by Lieuwer on December 01, 2001 3:14 AM

Is the VBA code that can check if thw ActiveSheet is protected or not?

Posted by Lymoges on December 01, 2001 3:23 AM


If Application.ExecuteExcel4Macro("get.document(7)") = True Then
MsgBox "Protected"
Else
MsgBox "Not Protected"
End If