Grouping rows and columns on a protected worksheet
 

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

Grouping rows and columns on a protected worksheet
 

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.
"Ron McCormick" wrote in message
...
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

Grouping rows and columns on a protected worksheet
 

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.


---
Message posted from http://www.ExcelForum.com/