Auto_Open & Add in

[MSweetG222]

All,

I had a workbook with an Autpen procedure in it that looked for selected
information within the workbook (like a sheet named "StartUp"). If found,
then the Autpen procedure would run.

I have since separated my workbook into 2 workbooks: 1) an Add-in and 2) a
Data Workbook w/ the "StartUp" worksheet info. (I plan on have several Data
Workbooks & I didn't want to maintain the code in several workbooks).

What do I need to do to the Add-in or the Data Workbook(s) that contains the
"StartUp" worksheet(s) to get the Autpen procedure in the Add-in to fire
when I open the Data Workbook?

I currently have an Autpen procedure in the Data Worksheet that calls the
Autpen procedure in the Add-in. This works, but I am not sure that this
is the proper way to code it.

In the Data Workbooks:
Sub Autpen
Application.Run "MyAddin!Autpen"
End Sub

Does anyone know the correct way to code this?

Thank you for your help...
MSweetG222

 

[Jim Thomlinson]

There is nothing wrong with what you are doing, except that it is slow. If
you need an efficiencly gain then you could create a reference to the addin
in your spreadsheet. Click on Tools -> References -> Find the Addin. If you
have not renamed the addin project it will just come up as project. You may
want to go into the Addin and change it's Name in the properties window. This
gives you a direct link to the addin and will improve the performance.

 

[MSweetG222]

Thank you! Speed is always important to me. I will change to your suggestion.

Thx again.
MSweetG222