Round Off function prevents undo
- karelk
- Topic Author
- Offline
- New Member
Less
More
7 years 8 months ago #1
by karelk
Round Off function prevents undo was created by karelk
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
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
Please Log in to join the conversation.
- Ian
- Offline
- Moderator
7 years 8 months ago #2
by Ian
Replied by Ian on topic Round Off function prevents undo
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
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
Please Log in to join the conversation.
- karelk
- Topic Author
- Offline
- New Member
Less
More
7 years 7 months ago #3
by karelk
Replied by karelk on topic Round Off function prevents undo
Hi Ian
Thanks for the reply. Still a very useful add in!!
Thanks for the reply. Still a very useful add in!!
Please Log in to join the conversation.