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

Similar Threads

Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Need some PWA help 0
Synchronization problems while moving folders to new email 1
Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time 1
Cell Protection? 2
Group and ungroup protected sheets 1
protect unprotect toggle VBA 6
ToggleButton to Unprotect/Protect all worksheets 0

Top