VBA: Undo function is not working in excel

[inddon]

Hello There,

I have a table in a worksheet and have worksheet change and selection procedure. I noticed when these fire the Undo key doesn't work. When I type something outside the table and do Undo it works.

I am using the below 2 statements to false and true:

  Application.ScreenUpdating = False
  Application.EnableEvents = False
....
...
...

  Application.ScreenUpdating = True
  Application.EnableEvents = True

Could you please advise what is the statement that can be included to perform all default actions again in the table as well.


Thanks & regards
Don

 

[NARAYANK991]

Hi Don ,

What you want done is not so simple , or even possible ; see this thread :

http://www.excelforum.com/excel-programming-vba-macros/705299-stop-undo-stack-from-clearing.html

The statements you have posted are used for other reasons , and are not necessarily related to the UNDO functionality.

Narayan