kskinne
Well-known Member
- Joined
- Feb 17, 2002
- Messages
- 1,267
- Office Version
- 365
- Platform
- Windows
Is it possible to use the OnAction property in order to refer to the name of a procedure contained outside the workbook that containing the OnAction code?
The code I want to refer to is in an add-in that is opened whenever Excel starts. I'd like to use OnAction to override the normal print command when the WorkBook is opened, and instead run my add-in code when the print button is pressed or print is selected from the file menu. It works fine when my code procedure is also contained in the same workbook, but I really need to keep my code in a separate add-in as there are multiple workbooks that this is needed in and I need to be able to make changes to my code in one spot.
Thanks,
Kevin
The code I want to refer to is in an add-in that is opened whenever Excel starts. I'd like to use OnAction to override the normal print command when the WorkBook is opened, and instead run my add-in code when the print button is pressed or print is selected from the file menu. It works fine when my code procedure is also contained in the same workbook, but I really need to keep my code in a separate add-in as there are multiple workbooks that this is needed in and I need to be able to make changes to my code in one spot.
Thanks,
Kevin