3

I just noticed that when AppSheetChanged event handler is implemented in Excel add-in, the Ctrl-Z (undo) functionality does not work. Any idea on how to make this work?

Brijesh Mishra
  • 2,738
  • 1
  • 21
  • 36
Benjsoft
  • 157
  • 2
  • 11

1 Answers1

4

Changes made by a macro/add-in cannot be undone with Edit: Undo. There are a few threads on StackOverflow that discuss this. Here's one.

Here's a page from Microsoft that states "In Excel, macros can clear all items from the undo list."

You can build in your own Undo functionality; here's an example of how to do it: Undo With Excel VBA - JKP

Community
  • 1
  • 1
Rachel Hettinger
  • 7,927
  • 2
  • 21
  • 31