Undo Disabled in Excel 2003 using VSTO 2005

[Darryn Lavery]

Re-posting from

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=925784&SiteID=1


Hi All,

I appear to have run in to an intractable problem in Excel 2003. I am
developing an auditing addin that monitors cell changes. I am capturing the
SheetChangedEvent and this disables the UNDO feature.

I have not seen this defined formally as being the case anywhere from MS. If
this is the case could someone let me know and point me to the resource?

If this is the case, can someone point me to a possible solution? I have
looked at _Application.OnUndo(), but this appears to require me to have have
macros on my spreadsheet, which defeats the purpose.

Any help would be very much appreciated.

p.s.

I have got it down to UsedRange method caousing the problem, if that is any
insight.

Regards

Frank