Clear Undo?

  • Thread starter Thread starter Zone
  • Start date Start date
Z

Zone

I'm clearing a bunch of drawing objects from my worksheet and
recreating them with VBA. Is Undo holding how all these old objects?
If so, I'd like to clear it and free up that memory. Excel XP (2002)
TIA, James
 
Undo doesn't record changes made by VBA.

So I don't think you have a concern there.
 
Based on what I have read about it, it is an ApplicationCommand Class command
which simply acts on the last transaction if the user invokes it. My
understanding is that it is the amount of transactions that you generate
before saving or closing that occupies the memory. However, I ain't all that
smart.
 
JLG, thanks for your reply. James
JLGWhiz said:
Based on what I have read about it, it is an ApplicationCommand Class command
which simply acts on the last transaction if the user invokes it. My
understanding is that it is the amount of transactions that you generate
before saving or closing that occupies the memory. However, I ain't all that
smart.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting Drawing Object By Name 3
Reduce Flashing 5
Can Turn Off Internal "Undo" Stack in VBA? 9
possible to enumerate objs from drawing toolbar - like textbox in 4
vba undo stack 1
Undo problems... again *sigh* 2
preventing macros from clearing the undo list 2
Change Event and undo stack 2

Back
Top