Excel Guides

Automatically Opening Macro Workbooks when Using a Shortcut Key in Excel

If you're like most people, you probably use Microsoft Excel to store a lot of important data. And if you're like most people, you probably have a lot of different workbooks that you need to access on a regular basis. Wouldn't it be great if there was a way to automatically open all of your macro workbooks with just a few keystrokes?

Well, there is! With a little bit of setup, you can configure Excel to automatically open all of your macro workbooks whenever you press a certain shortcut key. Here's how:

  1. First, open the workbook that contains the macros that you want to be able to access quickly. If you don't have a workbook already set up for this purpose, now would be a good time to create one.
  2. Next, open the Visual Basic Editor (VBE) by pressing Alt+F11. If the Project Explorer pane isn't visible, press Ctrl+R to show it.
  3. In the Project Explorer pane, double-click on the "ThisWorkbook" object.
  4. In the code window that appears, paste the following code:
Private Sub Workbook_Open()

  Dim wb As Workbook

  For Each wb In Application.Workbooks

    If wb.Name <> ThisWorkbook.Name Then

      If Not wb.ReadOnly Then

        wb.Activate

      End If

    End If

  Next wb

End Sub

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.