1) MsgBox ActiveSheet.ProtectContents

also check ProtectScenarios and ProtectDrawingObjects

2) application.Dialogs(xlDialogProtectdocument).Show

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Lp12" wrote in message
...
Hi All,
1) How can i inquire if a sheet is protected?
2) How can i programmatically call the protect sheet dialog box?
Thanks in advance....