Application.Undo fails in a big VBA project

[fadosolre]

Dear forum,
i'm trying to run this stupid code to simply undo every changes in a worksheet (in Excel 2007, no service packs):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Application.enableevents = False
Application.Undo
Application.enableevents = True
End Sub

It works well if I put it in an empty workbook. But if i put it in my big VBA project it works except when the user copy and paste something... weird thing! No errors are thrown!
I think it's not my VBA code's fault because i checked that this is the first sub called, so the UNDO stack is safe. In fact after the execution of this sub I can still call manually CTRL+Z and have a perfect UNDO. Or, if i run manually this code after automatic execution it works perfectly!!
If I erase all my VBA functions called from the sheets, there it works fine. So I think that there is something wrong with the number of functions called, although after this one.
Have you ever experiences this?? Do you have some possible solutions?
I'm becoming crazy!!!
Thank you very much
Marco

 

[Joe4]

Welcome to the Board!

See here: http://www.mrexcel.com/forum/excel-questions/400793-keep-undo-stack-when-running-macro.html
and here: Spreadsheet Page Excel Tips: Undoing A VBA Subroutine

 

[fadosolre]

Welcome to the Board!

See here: http://www.mrexcel.com/forum/excel-questions/400793-keep-undo-stack-when-running-macro.html
and here: Spreadsheet Page Excel Tips: Undoing A VBA Subroutine

Thank you, but my problem is different. The UNDO stack is safe because i can manually undo even after macro run...the problem is that the event isn't fired...

 

[Joe4]

the problem is that the event isn't fired

It is difficult to say without seeing your file and code, but it sounds to me that maybe something else is disabling your events (something else in your code), or your events are not being re-enabled (something may be causing it to exit your code before getting to the line of code that re-enable events).

 

[Norie]

Might want to see here too.

 

[Joe4]

Please note our stance on Cross-Posting. While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #10 here: Forum Rules).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered. For a more complete explanation on cross-posting, see here: Forum Rules).

 

[fadosolre]

It is difficult to say without seeing your file and code, but it sounds to me that maybe something else is disabling your events (something else in your code), or your events are not being re-enabled (something may be causing it to exit your code before getting to the line of code that re-enable events).

Yes you're right.
I created a very simplified document to demonstrate the error... if you paste a value in a cell that is used as input in a user-defined worksheet function the event is not fired!!

Do you think that there are solutions?? I think it's an Excel bug....what do you think? Maybe service pack 3, or Excel 2010 or 2013 fix this lack??

Thanksss!!

Click here to download:
https://www.sugarsync.com/pf/D8128723_60789919_951569

 

[Joe4]

It is always a good idea to make sure you are up-to-date on the latest patches.

But the problem may be something else. User Defined Functions do not get updated right away when one of their components changes unless you add the command "Application.Volatile" to the User Defined Function.