Undo Buffer/List

[hatman]

Once upon a time, when the Toolbar collection was exposed through the Application object, a savy programmer could parse the List collection of the Undo button and see just what the user's last few commands were. It was a back-door approach to gain access to data that was not directly exposed through the object model. Any idea if XL 2007 allows any read or write access to this list?

 

[RoryA]

The Commandbar is still there, so have you tried it?

 

[hatman]

Nope! Didn't even think of it! I just assumed it was absent... but then again, I should have realized it since the old toolbars in eth old addins from previous versions still load, just in teh Addin Tab...

I ended up finding a better way of handling what I was trying to do anyway. I'll have to keep it in mind that the Commandbar collection is still kicking around...