I know that as soon as I do something to Excel in VBA I
loose my undo buffer which is extremely annoying. I am
trying to get round this by building me own undo stack. I
can undo my code and I can store other changes from the
applications App_SheetChange event.

The problem I have is format changes do not fire the
sheet change event. Is there any way to detect when this
occurs?

Alternatively any other ideas on undo solutions would
also be much appreciated.

Thanks

Nigel