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.
"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

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/