auto_activate/auto_open routine not firing in Excel

[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

 

[akn846]

Its OK I think I've sorted it - I think it was cos it was under the general declarations rather than the workbook declarations

Andy