Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
All,
I had a workbook with an Auto_Open procedure in it that looked for selected information within the workbook (like a sheet named "StartUp"). If found, then the Auto_Open 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 Auto_Open procedure in the Add-in to fire when I open the Data Workbook? I currently have an Auto_Open procedure in the Data Worksheet that calls the Auto_Open 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 Auto_Open Application.Run "MyAddin!Auto_Open" End Sub Does anyone know the correct way to code this? Thank you for your help... MSweetG222 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AUTO_OPEN | Excel Discussion (Misc queries) | |||
Auto_open and more.... | New Users to Excel | |||
Auto_open and more.... | New Users to Excel | |||
auto_open? | Excel Discussion (Misc queries) | |||
XLA auto_open | Excel Programming |