Problems with auto open routines

[akn846]

I have placed some code into the auto_activate routine within my spreadsheet, and whilst I know that the code works when I run it manually from the VBA editor - whenever I open the spreadsheet though this code is not being executed.

Can anyone suggest to me some reasons why the auto_activate function would not be called when the spreadsheet was being opened.

Many thanks

Andy

 

[acron]

There is no such event as Auto_Activate. Perhaps you should name you sub Autpen.

Better still try the Workbook_Open(), which is available in ThisWorkbook code module.

A.C.

 

[ratman]

Try what acron suggested.

If you are in a workbook and are trying to execute code located in another workbook consider this:


Workbooks.Open ("\\LOUISE\pt\Plan Files\Plan.xls&quot
Application.Run "Plan.xls!PlanPageCode"


above run syntax: Workbookname!macroname