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

I don't believe there is any access to the editors undo stack.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"anandb" wrote in message
oups.com...
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