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

 

[RoryA]

My mistake. It's in the image of the code on the website you linked to, but not actually in the posted code. In that case, it should only be disabling the undo when the code is actually called -i.e. when one of your function inputs is being changed.

 

[smitpau]

Ah right okay I see, I'll respond back to this thread after seeing how the Undo VBA link goes.