Thanks Dave. Will try that.

"Dave Peterson" wrote:

You can put this into a General module:

Option Explicit
Sub Auto_Open()
Msgbox "Hi from Brent"
End Sub

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Brent E wrote:

Good day,

What is the command to run a macro as soon as a file is opened?

Thanks,

--

Dave Peterson