How to get workbook protection status?

[RobGodfrey]

I want to write a simple macro that allows the user to turn workbook protection on and off via a userform.
When the form starts up I want to set a drop down list to show one of On or Off options.
But I don't know how to find out if protection is already on or off. Can anyone help?

Here's my function

Please Login or Register  to view this content.

[DonkeyOte]

Welcome to the Board, please be sure to use CODE tags when posting VBA.

Given first post I've modified for you but going forward please bear the above and other Forum Rules in mind when posting

Thanks in advance.

In terms of answer - you might be looking for

Please Login or Register  to view this content.

[romperstomper]

Check the ProtectStructure and ProtectWindows properties of the Workbook.

[RobGodfrey]

Welcome to the Board, please be sure to use CODE tags when posting VBA.

Given first post I've modified for you but going forward please bear the above and other Forum Rules in mind when posting

Thanks in advance.

In terms of answer - you might be looking for

Please Login or Register  to view this content.

Thanks for the quick response

That works fine (will try to remember the code tags next time too)

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save