Hi
I have the following line of code:
Workbooks("Setup.xlsm").Close True
This is to close a sheet that is opened by way of VBA code (which it does so successfully) and to save any changes to that sheet on closing it.
This has recently started crashing with a Runtime Error.
Can anyone possibly suggest why this has just started happening recently?
Thanks
Liam
I have the following line of code:
Workbooks("Setup.xlsm").Close True
This is to close a sheet that is opened by way of VBA code (which it does so successfully) and to save any changes to that sheet on closing it.
This has recently started crashing with a Runtime Error.
Can anyone possibly suggest why this has just started happening recently?
Thanks
Liam