Thread: vba undo stack
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
anandb anandb is offline
external usenet poster
 
Posts: 2
Default vba undo stack

I have a question regarding the undo stack of the vba editor behind
excel (and not excel's undo stack).
I have written an event handler that every so often programmatically
updates code in a specific module in the project. This adds entries
into the undo stack that have nothing to do with the user's code
changes. To make the editing experience better I would like to be able
to do one of the folliwng things (in order of preference) but don't
know how to

a) temporarily disable additions to the undo stack
b) selectively remove entries from the undo stack without actually
undoing the change
c) clear the entire undo stack, again without undoing the changes

Any help would be greatly appreciated.

Thanks,
Anand