galileogali
Well-known Member
- Joined
- Oct 14, 2005
- Messages
- 748
I have an open workbook.
Add a CommandBarButton type CommandBarControl, assigned to the button a macro that I have in the same workbook. (Control.OnAction = "Macro1")
I close the WorkBook where resides the macro (Macro1). Is there any way to run Macro1, despite the fact that the book is closed?Do I put the code in Personal.xls? Do I need to design an ADDIN?
Add a CommandBarButton type CommandBarControl, assigned to the button a macro that I have in the same workbook. (Control.OnAction = "Macro1")
I close the WorkBook where resides the macro (Macro1). Is there any way to run Macro1, despite the fact that the book is closed?Do I put the code in Personal.xls? Do I need to design an ADDIN?
