ExcelBanter - Is sheet protected

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Is sheet protected (https://www.excelbanter.com/excel-programming/357213-sheet-protected.html)

Lp12

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

Bob Phillips[_6_]

Is sheet protected

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

All times are GMT +1. The time now is 12:14 PM.