| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group and Outline on a Protected Sheet
Hello all,
I have an Excel sheet that I use the Group (Data|Group and Outline|Group) to group certain rows. If I protect that sheet, I would not able to expand or collapse the groups. I tried turn-on various items (and all items) when I protect the sheet, and it still would not let me expand or collapse. Is there a way I can use the Group on a protected sheet? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet protection and "Group and Outline" | Excel Discussion (Misc queries) | |||
| Group & Outline in Protected Worksheets | Excel Discussion (Misc queries) | |||
| How to Use Group and Outline function when locked sheet | Excel Worksheet Functions | |||
| How can I allow an outline to be collapsed on a protected sheet? | Excel Worksheet Functions | |||
| Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
