Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I'm using Excel 2007. I have it outlined so I can expand and collapse it.
I've used it ok for months, expanding and collapsing it when protected, no problem. I'm very new to VBA. I've been adding some new code, finally got it so it works right, but now I get this message "you cannot use this command on a protected sheet" when I click on the expand/collapse symbols. I have no idea what changed. I deleted all my new code but no luck. It is not a shared spreadsheet. I have tried ActiveSheet.EnableOutlining = True, but makes no diff. What in the world changed? Thanks for any ideas you may have. Harold |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Group and Outline on a Protected Sheet | Excel Discussion (Misc queries) | |||
Capture outline expand event? | Excel Programming | |||
Outline, expand or collapse via VBA | Excel Programming | |||
How can I allow an outline to be collapsed on a protected sheet? | Excel Worksheet Functions | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) |