View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PO PO is offline
external usenet poster
 
Posts: 66
Default 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