Round Off function prevents undo

Hi Ian

Thanks again for your great addin. I have noticed that after using the round off function the undo button turns grey and prevents you from going back by clicking the undo button. Is this a known problem or just me.

Thanks
Karel

Hi Karel,

Thank you for your post.

The issue you have raised is not unique to you, nor to the round off function. Any time VBA code that manipulates the content of a spreadsheet is executed, it effectively clears the undo stack. This is more of a limitation in VBA than a bug really.

Since the entire addin is currently written in VBA, executing the addin's code effectively prevents use of the undo function from that point backwards. This means that selecting any of the options from the Ian's Excel Addin menu that manipulate your spreadsheet, will wipe out your undo history up to that point. Normal undo functionality, as built into Excel, will start again with no history once you start editing your spreadsheet again.

Kind regards,
Ian

Hi Ian

Thanks for the reply. Still a very useful add in!!