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
|