How do you allow hide/unhide or group/ungroup features while protected

Hi,

We have a file that needs to be updated monthly by running macros, but the macros are being blocked by protection. I would like to put some code at the start of the macro that unlocks all sheets and then at the end locks them up again. Actually, all I really need is a macro to do just that unlock all sheets, and then another one that locks them back up again as we will need to lock and unlock at various times and it is annoying to have to do it by sheet.

The password is "ou" I do not know if that matters.

If this macro is possible, will it keep the selected parameters that you check when you go in an protect something?

Thanks tons in advance.

Hi

If you use something like the following it shoud work okay

Please Login or Register  to view this content.

To protect when you finish use a similar macro but change unprotect to protect.

Regards

Jeff

If you protect the sheet from VBA with the UserInterfaceOnly option, you won't need to unprotect them to run the macros.

Originally Posted by solnajeff

Hi

If you use something like the following it shoud work okay

Please Login or Register  to view this content.

To protect when you finish use a similar macro but change unprotect to protect.

Regards

Jeff

TTTTTTTTTTHHHHHHHHHHHHAAAAAAAAAANNNNNNNNNNKKKKKKKKKKKKSSSSSSS!

That is exactly what I needed, AWESOME!!

Originally Posted by shg

If you protect the sheet from VBA with the UserInterfaceOnly option, you won't need to unprotect them to run the macros.

My coworkers do not understand the VBA code and so I have to provide them with buttons, but I do have one other question...

Is there a way to protect and yet allow hide and unhide? Does not seem to be an option for that, but maybe there is a back door way to do that. Our file needs to be protected, but we have a bunch of stuff grouped so that we can hide it easily but we want to allow it to be unhidden.

Hi,

I have a protected worksheet that has several lines that are grouped (hidden) that users can't unhide by cliking the +. How do you allow this wile the sheet is protected?

Thanks.

Originally Posted by davesexcel

don't think you can
here's a vba code you could assign to a button

Please Login or Register  to view this content.

That is good, but I need the sheet still protected so they can't change stuff, but still allow hide unhide

Originally Posted by shg

If you protect the sheet from VBA with the UserInterfaceOnly option, you won't need to unprotect them to run the macros.

You know this may work, how do you do this? I would like to be able to allow several of the options given in the list of options when you protect, but also hide and unhide (allow my people to push the + - for group and ungroup). Is there code for these options?

Want users to be able to:
Select both locked and unlocked cells
format locked cells, columns, and rows,
hide and unhide locked rows and columns (push the + - on grouped cells)
insert hyperlinks (though that really isn't a concern, just an option they will probably never use)

Thanks so much for any help.

Look at Help for the UserInterfaceOnly option and post back if you have further questions.

Originally Posted by shg

Look at Help for the UserInterfaceOnly option and post back if you have further questions.

I have found a lot of code for this, but I can't find how to specifically tell it to allow hide and unhide when protecting. I think I understand how to build it as a userInterfaceOnly, but how do you say allow hide and unhide. I found some code done in C++ or # what ever it is and it shows this...

Please Login or Register  to view this content.

That is what I want, the specific categories in VB that let you tell it what you want to allow.

Thanks guys, I got enough information from you all to figure it out on my own. Plus some search help reading some stuff from VBNoob. Thanks to him as well.

Here is the solution:

Please Login or Register  to view this content.

Thanks!!

Here's a much simpler one.

Place this code in ThisWorkbook

Please Login or Register  to view this content.