Excel VBA Undo Issues

[smitpau]

Hi,

Appreciate the title is quite broad so I'll be specific.

I'm using the code from the website below, it basically creates a "User Defined Function" (UDF) in Excel which can be used to change chart axis values.

It's quite helpful but now the Undo feature stops working.

Is there some sort of workaround such as having a Macro Button to trigger when to start the code as it doesn't need to be constantly calculating in the background as hopefully then Undo will work like normal.

If anyone has any ideas it would be much appreciated.

Thanks for reading!

Link:

How to set chart axis based on a cell value

The chart axis min and max settings are fixed values. This posts looks at a automated method to set chart axis based on a cell value.

exceloffthegrid.com

 

[Logit]

I suspect something else is occurring at your location. The workbook "undo" function works as expected here.

 

[Joe4]

I suspect something else is occurring at your location. The workbook "undo" function works as expected here.

Undo does not work on actions done through Macros/VBA.

If you want to Undo Macro/VBA changes, you need to code for that in VBA.
See here: How to Undo a Macro with VBA OnUndo and OnRepeat - wellsr.com

 

[Logit]

Again: " The workbook "undo" function works as expected here. "

The Menu Bar "Undo" arrows function well here.

I inserted a short macro :

Sub Undu()
Application.Undo
End sub

And found the macro will perform an UNDO action once. Attempting to run the macro more than once creates an error.

 

[RoryA]

I'd start by removing the line that makes the UDF volatile. If you're passing the necessary Min/Max values to it as arguments, you shouldn't need it to be volatile.

 

[smitpau]

Thanks for the comments, I'll check out the how to undo a macro link.

RoryA maybe a basic question but how do I check the line(s) that are volatile in the VBA, as the Min/Max values are cell references so believe this may solve it.

 

[smitpau]

Logit initially I could undo once at a time (similar to you) but after more of these UDF's that have been added the undo functionality has stopped working at all.

 

[Joe4]

Yes, I was also able to use the built-in Undo once on a very simple Macro (which surprised me), but unable to after that, even if I closed Excel and re-opened.

 

[RoryA]

Just remove the line that starts with Application.Volatile in the UDF, then re-enter one of the UDFs.

 

[smitpau]

Sorry RoryA don't quite follow, where is the line Application.Volatile as I can't seem to find it.