If the workbook you are opening needs this macro to be run everytime the workbook is opened you could put it in a Auto_Open macro or place it in a Workbook_Open event in the workbook you are opening.

Have you also tried Call to run the macro "Call Macro1".

Hope this helps