This is an OOP based problem - I think...

Borrowing heavily from Bullen, Bovey & Green's 'Professional Excel
Development' I've written an Excel 2003 app, which helps an
organisation list their portfolio of current and future production
runs and tinker with the pipeline dates, resource loads and what have
you.

The portfolio itself is a datalist in a defined (expandable rows) area
on a sheet and this range is encapsulated within a couple of classes -
clsPortfolioItem (each row) and clsPortfolioItems (the collection of
rows). This allows me to give each portfolio item properties like
Locked, Valid, Ticked.

The problem I'm having is that if the user decides to delete, say, 500
rows of portfolio items it can take 30 seconds or so before the
Sheet_Change event fires and during this time Ctrl+Break is ignored.

What's it doing and is there a way I can speed things up?

Br Nick H