Working macro but disables Undo

I have copied some formula somewhere and adjusted it to what I need and the macro does what it needs to do.
It simply widens the column when selected.

However because of the nature of selectionchange thingy it also makes the Excel workbook unable to use "Undo" which is kinda annoying.
anything I can do about this?

Please Login or Register  to view this content.

There is no way to preserve the undo stack. When a VBA macro is called, it clears Excel's undo stack. As I note in the discussion linked below, there could be value in exploring how important the VBA macro is to the project and balancing that against your desire to maintain an undo stack. If the macro is more important than the undo stack, then you use the macro with the understanding that you may not always have a functional undo stack. If the undo stack is more important, then you need to find a non-macro way to accomplish what the macro is doing.

The only way around this that I have seen is from this discussion, where you create a class module and procedures to effectively store the workbook state with procedures to retrieve the stored information: https://www.excelforum.com/excel-pro...tion-back.html While you are running cost-benefit analyses on this programming task, see if it is worth the effort to implement this option.