| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protected cells can't be grouped | Excel Worksheet Functions | |||
| Hyperlinks in cells in a protected worksheet not working | Excel Discussion (Misc queries) | |||
| Using Grouped Rows in Protected Worksheet | Excel Discussion (Misc queries) | |||
| How can I use open/close Grouped cells in a Protected Worksheet? | Excel Discussion (Misc queries) | |||
| Protected sheets and cells | Excel Worksheet Functions | |||
Hybrid Mode
