Hi

I posted this question a month ago but nobody seems to know an answer to the
problem. I haven't been able to find a workaround so I would deeply
appreciate if anyone has ANY idea concerning my problem which is as follows:


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) will result in an error. 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