grouping and ungrouping a protected sheet

M

Manjunath

An excel-worksheet with grouping is protected,
1) It makes the worksheet readonly
2) It doesnot allow to see grouping. User cannot switch
between different level of group.

Is there a way to retain 1st feature but not the second
one.
 

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

Protected Sheet and grouping 1
Expanding Grouped Rows when sheet is Protected 2
Allowing for Grouping and Ungrouping while Sheet is Protected 2
How to enable grouping in a protected sheet 2
how do I get excel to use tab to move in a sheet 2
Grouping Function on protected sheet 1
How to protect sheet allowing grouping and ungrouping but alsoallowing changing colour of specific c 2
Grouping with protected sheets (multiple sheets) 0

Top