Is sheet protected

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....

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" <[email protected]> wrote in message
news:[email protected]...
> 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....
>