Run macro from another spreadsheet?

[karmadog62]

Hi,

Is it possible to have a command button that is assigned to a macro in another workbook? I have a huge workbook with many formatted sheets. I currently have a dashboard in the same workbook that has multiple command buttons with each button assigned a macro that opens a specific worksheet and creates a PDF ready to print. I'd like to move that dashboard to a separate workbook.

Thanks for any advice!

[JBeaucaire]

I suppose. What you'd be doing is having the buttons in the Dashboard workbook:

1) Test to see if your main workbook is already open.
2) If the workbook is not open, the macro would open it.
3) Once the macro has detected the open workbook (1) or opened it because it was closed (2), set a wb variable to reference that workbook
4) Proceed to process the designated worksheet from that workbook the way you do now, except be sure to add the wb reference to keep the object connected during the macro run.


Sample snippets:

Please Login or Register  to view this content.

[karmadog62]

Thanks Jerry!

[JBeaucaire]

I've made a correction above to the usage of the wasOPEN variable.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[karmadog62]

Thanks for all your help!