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:


Please Login or Register  to view this content.
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.