Working with Grouped cells on Protected sheets
 

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

Working with Grouped cells on Protected sheets
 

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
.

Working with Grouped cells on Protected sheets
 

Thank you...


-----Original Message-----
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
.

.