I have a macro that enables a simple Undo of a macro update of a sheet.
After the macro is run the user is asked if they want to Undo the update.
With 2016 I'm experiencing a problem shown in the image at https://www.screencast.com/t/AVZvslfnhFM
which is also described below...
If they say YES to the Undo, in all versions of Excel PRIOR to 2016, the Workbook Open command shown in the above link is executed and the command gives the "Reopen" message also shown in the link.
However, in Excel 2016, for some reason the "Reopen" message does not get displayed when the Workbook Open command is executed, and the previous saved workbook does not get opened, and so the Undo doesn't work.
Any ideas are appreciated.
After the macro is run the user is asked if they want to Undo the update.
With 2016 I'm experiencing a problem shown in the image at https://www.screencast.com/t/AVZvslfnhFM
which is also described below...
If they say YES to the Undo, in all versions of Excel PRIOR to 2016, the Workbook Open command shown in the above link is executed and the command gives the "Reopen" message also shown in the link.
However, in Excel 2016, for some reason the "Reopen" message does not get displayed when the Workbook Open command is executed, and the previous saved workbook does not get opened, and so the Undo doesn't work.
Any ideas are appreciated.
