Reset Excel's undo/redo cache after programmatic modification

Add-in Express™ Support Service
That's what is more important than anything else

Reset Excel's undo/redo cache after programmatic modification
 
Marcel Mrozinski




Posts: 3
Joined: 2019-10-28
Hi everybody,
it is an old topic, but there may be news about it. Is there a way to reset the undo/redo cache using ADX after a programmatic modification of an Excel COM add-in to a workbook/sheet/cell so that the user can perform undo or redo of the previous actions as usual?

With best regards,
Marcel Mrozinski
Posted 02 Jan, 2020 11:33:44 Top
Andrei Smolin


Add-in Express team


Posts: 17355
Joined: 2006-05-11
Hello Marcel,

In my tests any modification of a sheet made by a COM add-in or a VBA macro clears the Undo stack thus disabling the Undo control.

I believe there's no way to bypass this.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 03 Jan, 2020 03:32:17 Top