Grouping rows and columns on a protected worksheet

R

Ron McCormick

Is there a straightforward way to activate the grouping
facility on a protected worksheet? I have a colleague who
is wanting to allow users to hide/unhide certain columns
on a worksheet without having the capability of
unprotecting the sheet.

TIA
Ron
 
M

Mike Fogleman

From a couple of Command Buttons on the sheet, one will unprotect, unhide,
protect. The other will unprotect, hide, protect. The second macro can also
be run upon Workbook_Close to make sure it gets put back to the unhide
state, but with an error trap in case it is already hidden when closed.
 
B

BrianB

You have to put your own buttons on the sheet to do the job, which
momentarily unprotect the sheet, change the view, and protect again.
 
Top