Cannot expand/collapse outline groups on protected sheet


B

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?
 
Ad

Advertisements

D

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

Advertisements

B

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top