closing workbooks

  1. L

    Opening and closing multiple files

    Hello, I have a code that works great. The code opens all the files in a folder and compiles it to a table on my master spreadsheet. The problem I have is that when the program opens the files I have to click on update for each file because they all have link to a database. It's a lot of files...
  2. S

    Run Protect Macro on Close

    Excel 07. I have unprotect and protect macros that run when I click on two different buttons. Sometimes, the tech (end user) forgets to reprotect the workbook before closing it. How can I get the macro I already have (which protects 7 worksheets with different passwords) to run automatically...
  3. V

    VBA code to close inactive workbooks

    I tried to use Workbooks("Inactivebookname.xlsm").Close False and many variations thereof, but I simply cannot close this workbook when currently another workbook is active. I have no problem in closing an active workbook with ActiveWorkbook.Close Please Help. Thanks.

Watch MrExcel Video

This Week's Hot Topics

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
Top