Hi There, I have a "macro sheet" that holds all my macros. I've created buttons to apply people to visually run a variety of macros on different worksheets, however I cannot pre-define which worksheet they'll want to run a macro on. I've found the following code which ALMOST does what I want: Dim ws As Worksheet Application.CommandBars("Workbook Tabs").ShowPopup Set ws = ActiveSheet but this only shows a popup of the worksheets in the current workbook. I want the popup to allow the user to select any workbook that is open - then run the macro on that workbook.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Popup Workbook Selector

Thread starter lordterrin
Start date Mar 26, 2013

lordterrin

Board Regular

Mar 26, 2013

Hi There,

I have a "macro sheet" that holds all my macros. I've created buttons to apply people to visually run a variety of macros on different worksheets, however I cannot pre-define which worksheet they'll want to run a macro on.

I've found the following code which ALMOST does what I want:

Code:

Dim ws As Worksheet
        Application.CommandBars("Workbook Tabs").ShowPopup
    Set ws = ActiveSheet

but this only shows a popup of the worksheets in the current workbook. I want the popup to allow the user to select any workbook that is open - then run the macro on that workbook.