the question was when you open excel...

so you must open a file first that has a workbooK_open eventhandler.

that can be: any activated addin.
any file in the xlstart folder
any file in the folder listed under:
tools/options/General
"at startup, open ALL files in"


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Neil Hopkinson wrote :

it doesn't seem to work though, any more ideas?

"Neil Hopkinson" wrote:

that's exactly what I mean, thanks

"Charlie" wrote:

If you mean when you open an existing workbook try putting your
code in:

Private Sub Workbook_Open()

End Sub


"Neil Hopkinson" wrote:

Is it possible to set up a macro that automatically runs when
you open excel?

Thanks