Cannot expand/collapse outline groups on protected sheet

[Blue Max]

A continual frustration for us has been the inability to expand/collapse
outline groups when a sheet is protected in Excel 2007. There are many
options that can be excluded when protecting a sheet, but we do not see an
exclusion for the outline option. Is there another option somewhere that
will allow the user to perform this operation on a protected sheet?

 

[Daniel Haley]

The only other option would be to put in macros that unprotect the
sheet, hide or unhide certain groups, and then protect again. In most
situations I don't think this is a very workable solution.

 

[Blue Max]

Thanks, Daniel, we have tried that before. It works, but it always requires
added overhead and execution steps. It would appear simple for Microsoft to
add this item to the "Allow all users of this worksheet to:" list in the
protection dialog. Wish they would seriously consider adding a few more
common items, such as the one above.

Thanks,
Richard

*****************