Yes, put it in a macro called Auto_Open, or add it to the Workbook_Open
event in the ThisWorkbook code module.

--

HTH

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


"blonde1030" wrote in message
...
Hi Bob, jumping in here too: Do you know how to make a msgbox popup
automatically upon opening the file?

"Bob Phillips" wrote:

Of course

Msgbox Range("A1").Value & "', your email has been sent",
vbInformation

--

HTH

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


"ynissel" wrote in message
...
Bob,
Great - thanks, worked like a charm !
Can I spiff it up - like input the users name from a specific cell
(a1)
into
the statement ?
Yosef

"Bob Phillips" wrote:

msgbox "Your email has been sent", vbInformation

It5 also shows one of those information buttons.

--

HTH

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


"ynissel" wrote in message
...
How do I get my macro to pop up a message box that says "your
email
has
been
sent" and just an OK button to continue ?
Thanks