If you create the following in a standard module in a workbook:

Sub Auto_Open()
'do stuff
End Sub

it will be automatically executed when the workbook is opened.

On_open has no particular significance to Excel as far as I know.

--

John Green - Excel MVP
Sydney
Australia


"Nathan Gutman" wrote in message ...
What is the difference between Auto_open and On_open?
Where can I find a written explanation?
Thanks,
Nathan