close open workbooks

  1. A

    Closing linked Workbooks

    I am getting an error when the scheduled autosave feature that also updates links in my workbook finds the source workbooks open. It runs with no problem when the source WBs are closed. Sub SaveBook() With ThisWorkbook .Sheets("Receiving").Select .UpdateLink...
  2. M

    Error Handler - Close Workbooks if open

    Can someone explain to me why excel won't let me do this? What I want is for any of my three workbooks that might be open to be closed upon macro error. Testing this doesn't work as excel yells because during testing I don't open one file to make the error happen. Bunch of code that leads to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top