Excel's VB

[Crystal Dragon.]

How do i get a macro to run automatically when I start up Excel? All I know is that it would be part of PERSONAL.xls, but not sure what the right sub() name would be...

[CallMeCrazy]

I think that the subroutine needs a name of "Auto_Activate" (or something similar). I can't quite remember.

[General Kenobi (ret.)]

Put it in the Workbook_Load event (I think--I'll check to be sure tomorrow).

[CaptainCavy]

In a workbook Module (not in a sheet),

Sub Auto_Open()
' insert code here
End Sub

(Tested and working fine on Excel 97 and I believe 2000 as well).

cc: