Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem using outlines
I'm using outlines in an Excel 2000 spreadsheet. The problem is that some
parts of the worksheet have to be protected so clicking the outline symbols (+/- or 1|2) won't work. I therefore, somehow, would need to unprotect the workbook before the expand/collapse event is triggered and thereafter reprotect it. The problem is that there is no BeforeExpand/collapse event, none that I could find anyways. 1. Can this be solved using standard VBA? 2. or if not - is there a API-function(s) I can use? TIA PO |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel - outlines | Excel Worksheet Functions | |||
Sub-total outlines | Excel Worksheet Functions | |||
Sorting Outlines | Excel Worksheet Functions | |||
Excel Outlines | Excel Worksheet Functions | |||
Using Outlines in Excel | Excel Discussion (Misc queries) |