Grouping rows and columns on a protected worksheet

  • Thread starter Thread starter Ron McCormick
  • Start date Start date
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
 
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.
 
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.
 
Back
Top