Capture undo history before event in excel

Question

It is a known problem/bug that using event handlers in excel kill the undo buffer, I searched the internet for a solution but could not find it. So I was wondering if i could just capture the undo buffer as the first thing in my event; do what ever I want in my handler and then place the buffer back to where it belongs. Or is maybe this bug solved in excel 2010?

Answer 1

Hi,

Try this: http://social.technet.microsoft.com/Forums/en-us/category/officeitpro

Answer 2

For those of you who are interested in this; my question somewhere else on this forum generated more replies:

http://social.msdn.microsoft.com/Forums/eu/exceldev/thread/9ef5ac45-9c62-4f17-a074-e9e8326941b0