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.