AutoExec in VBA

[Guest]

How do I write code in a module that will act like an AutoExec macro?
Basically, I need the same results that "sub Auto_open()" would give in
Excel.

 

[Douglas J. Steele]

Create an AutoExec macro that calls your code. (Remember that macros can
only call Functions, not Subs)

 

[Guest]

Write your code as a function.
Use the RunCode action in the Autoexec macro and specify the name of the
function.
The RunCode action will only run functions. No return value is required.

 

[Guest]

Excelent

Create an AutoExec macro that calls your code. (Remember that macros can
only call Functions, not Subs)

 

[Guest]

Thanks

Write your code as a function.
Use the RunCode action in the Autoexec macro and specify the name of the
function.
The RunCode action will only run functions. No return value is required.