Ability to Group and Ungroup while in Protection Mode

F

FredL

I have a worksheet that I'm trying to protect the formulas (with some cells
that are unprotected for user input). Because it is rather large, I want to
be able to group it so that the user can toggle between a summarized or
detailed view. I'm using the grouping functionality and have preset the
groups.

However, when the sheet is protected, users cannot toggle between the
grouping level; it is frozen at whatever it was when it was protected.

Is there anyway this can be modified so that users can toggle when in the
protected mode?

Thanks.
 

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