Thread: Clear Undo?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Zone Zone is offline
external usenet poster
 
Posts: 269
Default Clear Undo?

JLG, thanks for your reply. James
JLGWhiz wrote:
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.

"Zone" wrote:

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