I'd like to set a macro so that when the file is opened, it automatically runs.

Put the code in the Workbook_Open event in the Thisworkbook code module.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kanye" wrote in message
...
I'd like to set a macro so that when the file is opened, it automatically
runs.

I've located the Thisworkbook code module, but see nothing about
Workbook-Open event. Where do I look for this?

"kanye" wrote:

I'd like to set a macro so that when the file is opened, it automatically runs.

see my response to the question you posted 1 min before the one Bob answered
.... titled "Automatic Message"

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"kanye" wrote in message
...
I've located the Thisworkbook code module, but see nothing about
Workbook-Open event. Where do I look for this?

"kanye" wrote:

I'd like to set a macro so that when the file is opened, it automatically
runs.

Input this into the Thisworkbook code mould

Private Sub Workbook_Open()

End Sub

and add your code to it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kanye" wrote in message
...
I've located the Thisworkbook code module, but see nothing about
Workbook-Open event. Where do I look for this?

"kanye" wrote:

I'd like to set a macro so that when the file is opened, it
automatically runs.

Thanks to you both, this works well.

"kanye" wrote:

I'd like to set a macro so that when the file is opened, it automatically runs.