Windows XP How do I Auto Start a Macro

[Dennis Gray]

How do I auto start a macro when I open an excel file?

 

[JaLing]

Unless it's signed / fully trusted..... you can't.
You can code it to but Microsoft have applied security features to prevent it.
It's a big vulnability.

 

[Dennis Gray]

what is the auto start code for a macro
This is what VB has in it's help file:

"This example opens the workbook Analysis.xls and then runs its Auto_Open macro."
Workbooks.Open "ANALYSIS.XLS"
ActiveWorkbook.RunAutoMacros xlAutoOpen

Does the name of the macro go in the place of :AutoOpen or is AutoOpen the name of a file that has the macro in it that you want to open?