Forum Discussion
Excel Undo Function Not Working Properly in Workbook with UDF
I am having a problem with Excel's undo function in a macro-enabled workbook that contains a user-defined function. If I take a bunch of random actions and then click the down-arrow next to the undo...
egurs This is a well documented issue. Google for instance for "undo stack excel cleared after running VBA" and you'll find many resources discussing it, like the one in the link below.
Riny_van_EekelenThanks for the lead. Looks like the issue was the "Application.Volatile True" line in the VBA code of the UDF. Took that out and undo is working again, with no apparent impact on the functionality of the UDF.
- Presumably that means you are OK up to the point at which you force the function to evaluate.
There are techniques like running the code from a validation condition or a hyperlink where the normal restrictions of UDFs a bypassed but that is not my normal territory. - If only I knew how to do this 😞
