| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect worksheet but expand and collapse outline?
I'm currently using Excel 2003 and building a spreadsheet that has a lot of
columns and formulae. I protected the sheet and unlocked the relevant cells. However, before protecting the sheet, I also outlined the sheet making it easy to expand and collapse the relevant months. But when the sheet is protected, I lose this functionality. Is there any way to protect the sheet but still allow users to expand and collapse the relevant months? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expand/Collapse Grouped Data in Protected Worksheet | Excel Discussion (Misc queries) | |||
| Collapse and expand data | Excel Worksheet Functions | |||
| Expand/Collapse Rows | Excel Worksheet Functions | |||
| how to protect excel worksheet and still use the outline buttons? | Excel Worksheet Functions | |||
| expand/collapse row button | Excel Discussion (Misc queries) | |||
Threaded Mode
