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

User controlled Freeze Pane while protected 3
Userinterfaceonly 5
Using Group and Outline with Protected Cells 1
Expanding Grouped Rows when sheet is Protected 2
Ability to Group and Ungroup while in Protection Mode 0
Allowing for Grouping and Ungrouping while Sheet is Protected 2
Grouping Function on protected sheet 1
Grouping - + and - not showing attop of sheet. 0

Top