Custom Add-In?
I've created a new workbook with some VBA functionality
and a custom toolbar to call the functions. I have saved it as a .XLA and referenced it in the addins... My problem is that when I open up a new workbook and click on the custom button the source code for the .xla is opened instead of the .xla itself. What I want is to have the toolbar opened when the add-in is referenced and have the code run from within the .xla. How do I accomplish this? Thanks. |
Custom Add-In?
have the workbook.Open event of the XLA loop through the controls of the
toolbar and assign the onaction property to point to the xla. object.OnAction = thisworkbook.name & "!" & varr(i) where varr(i) contains the appropriate macro name. Or do this one time with external code. (replace thisworkbook.name with the name of the xla). -- Regards, Tom Ogilvy Phill wrote in message ... I've created a new workbook with some VBA functionality and a custom toolbar to call the functions. I have saved it as a .XLA and referenced it in the addins... My problem is that when I open up a new workbook and click on the custom button the source code for the .xla is opened instead of the .xla itself. What I want is to have the toolbar opened when the add-in is referenced and have the code run from within the .xla. How do I accomplish this? Thanks. |
All times are GMT +1. The time now is 10:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com