Unprotect Workbook Using UserInterfaceOnly

Greetings,
I am using the following code for my protected Worksheets when the Workbook Opens. Is there a way to use the same for the Workbook.

Please Login or Register  to view this content.

skywriter,
I opened the link you provided but did not see how to incorporate using the UserInterfaceOnly code.

Hi,

as like you can read in post #2 link or in VBA help UserInferfaceOnly does not exist at workbook level …

Marc,
Thank you for your reply.
I have several worksheets that are hidden. And these are accessed through a macro Ex: "Sheet15.Visible = True". Is there a way of unprotecting/protecting the Workbook without having to use the following code within every macro.

Please Login or Register  to view this content.

The question is do you need to protect the workbook, why not just the worksheets ?

I should have stated earlier - this workbook will be used by other individuals. I want to protect the workbook to prevent anyone from accessing the "data".

So once someone has the main password he can open and use the workbook as usual …

Correct. As well as possibly do harm to the programing.

So once the workbook is yet opened, your VBA procedures just need to take care of the worksheets status, protected or not,
or I'm missing anything ?

Once the workbook is opened, there are several worksheets that are hidden. The hidden worksheets are unhidden via a button (running a macro: "Sheet15.Visible = True"). I know I can insert code within the macro to unprotect/protect the workbook. However, I have many (200+) macros that will require inserting the code. I am wanting to know if there is a simpler way to unprotect/protect the workbook, instead of inserting the code into each macro.

If the workbook is opened with the main password so no need to unprotect the workbook normally, just need to manage sheets as usual …

I have attached a sample workbook that will indicate the issue I have with a protected workbook.

Ok sorry my bad I have made a so bad beginner confusion mixing the open password workbook vs the workbook protection !
So yes as it seems there is no trick to bypass the workbook protection so you need to unprotect the workbook if its structure was checked …