How to determine if the workbook is protected?

S

Shasur

You can try the following

Sub Check_If_WB_Protected()


If (ActiveWorkbook.ProtectWindows = True Or ActiveWorkbook.ProtectStructure
= True) Then
MsgBox "Workbook is protected"
Else
MsgBox "Workbook is not protected"
End If

End Sub


Cheers
Shasur
 
F

filo666

Thanks, exactly what I was looking for.

could you give it a check to my other post at top?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Determine if a sheet is protected? 4
Get Data set range from closed workbook 2
How to Unlock Excel Workbook protected by MACRO Password 6
How to determine whether a protected sheet has a password? 1
Cant see worksheet tabs in a workbook 1
dont open a Workbook is Password protected 2
Sharing workbook removes cell protection 1

Top