I noticed that the same question was answered yesterday by
Tom Ogilvy so here was his reply. I hope you don't mind my
repasteing it, Tom.

sivrik.


If excel 97 or later:
Look in Excel VBA help for EnableOutlining

You will need to use it in conjunction with the
UserInterfaceOnly argument
for protection.


This all needs to be set with code when you open the
workbook each time.


Regards,
Tom Ogilvy

-----Original Message-----
Hello Lists...
How can I allow users to expand and collapse grouped rows
if the sheet is protected? What I'm trying to achieve is
the ability to view a report in full or collapsed
version.. without the ability to update any cells.
Should
I use something other than protected sheet?

Thank you,
Jeff
.