Undo disabled using Worksheet_Change event in Excel

Hot Topic

Read from Excel files
Work with DHTMLEdit
Current Record
Change DB connection
Refactor
Databases vs Files... which ones best?
Windows Installer error message
outlook problems after uninstalling VB
VB.NET Database Connection
Treeview Node Search (also node level)

Visual Basic

playing mp3 file..
CodeSnippets Manager
LinkLabel
Updating underlying table
Binding Navigator Next Item
ActiveForm strangeness
MyPrinter
Reports for Visual Basic 2005
How to show a filename without showing filepath
Controls Flickering when drawed on the form

Undo disabled using Worksheet_Change event in Excel

I'm using the Worksheet_Change event to produce a date/time stamp in an Excel workbook.  The problem is when using this event it disables the Edit|Undo feature in Excel.  Is there a relatively easy way around this problem without writing a whole bunch of code to capture cell values and then manually creating an Undo command button

BTW, why does this event disable Undo   Undo is an important feature is most cases.  Is this a bug you guys are working on   I appreciate your help.

Thank you.

Answer this question

Undo disabled using Worksheet_Change event in Excel

  • PabloSmith

    From what I understand, any code executed by Excel VBA clears the undo buffer, not specifically code executed in response to this event.

    There is an Application.OnUndo method, but it doesn't do exactly what you want. However, it might be helpful somewhat, so take a look at it.

    I'm not a VB expert, so there might be better or more current info on this issue that what I'm providing, but it's the best I can offer.


  • Undo disabled using Worksheet_Change event in Excel
Answer this question