Forum Discussion
SaveCopyAs clear memory? Undo not working
Hello, I've created "AutoSave every 5 min" by using "ThisWorkbook.SaveCopyAs file.xlsx", but noticed after doing SaveCopyAs Excel loses memory on function "Undo". Can someone explain me why? or g...
Hi,
Unfortunately, there is no option to undo the effects of a VBA code.
But there are some workarounds like http://spreadsheetpage.com/index.php/tip/undoing_a_vba_subroutine/.
Regards
This is strange. If i press button Save the Undo works, if i use ActiveWorkbook.save the Undo already does not work.
Hi,
The reason why is the code behind the Save Button is native code, and it differs from the ActiveWorkbook.Save which is a VBA code.