Unhide Grouped Cells - Protected Sheet

Hi All,

I have a few columns that grouped together and therefore get hidden using the (+) in the document. When the sheet is password protected I am unable to "open" the group. Are the specific settings to apply that will allow me to have the sheet password protected but still keep the functionality of the group hide/unhide? I need to have the cells in the group un-editable though.

Thanks.

Are you willing to use VBA Code to do this.

What will the VBA code do? I need users of the workbook to b able to use the grouping option, without unprotecting the sheet.

What colums do you need to hide and unhide.

This would be for the columns that are grouped together.

Currently my report has 3 groupings, but I want to be able to hide and unhide them independently. The number of "grouped columns" could also increase with time.

Current Grouped Column Ranges:
V:AG
AK:AX
AZ

Is This Basically what you are whanting to do.

Yes that's exactly it

Got it to work with what you did, thank you.

Just Go to the Developer tab and add in active X Check boxes then add the codes to them

http://www.addintools.com/documents/...loper-tab.html

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

No Problem