View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AccessHelp AccessHelp is offline
external usenet poster
 
Posts: 213
Default 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.