How- Message box on opening excel file?
 

Hi All,

Can any one help with this please?

All I want is a message pop-up box saying "Blah Blah Blah" first thing
when I open an excel file?

I used to know but it's completely gone from my head,

It's something like "On Open" or somethng like that?!?

I'm miffed!

Thanks for some help on this guys?

Buck:confused

--
Message posted from http://www.ExcelForum.com

How- Message box on opening excel file?
 

Sub Auto_Open()
Msgbox "Blah Blah Blah"
End Sub

--
Regards,
Tom Ogilvy


"Buck247 " wrote in message
...
Hi All,

Can any one help with this please?

All I want is a message pop-up box saying "Blah Blah Blah" first thing,
when I open an excel file?

I used to know but it's completely gone from my head,

It's something like "On Open" or somethng like that?!?

I'm miffed!

Thanks for some help on this guys?

Buck:confused:


---
Message posted from http://www.ExcelForum.com/

How- Message box on opening excel file?
 

Hi Buck

All I want is a message pop-up box saying "Blah Blah
Blah" first thing,
when I open an excel file?

I'm sure this would have come back to you in a few
minutes, anyway ... ;-)

Start VBA
In the ThisWorkBook module, enter:
Private Sub Workbook_Open()
MsgBox ("Blah Blah Blah")
End Sub

Of course you also could have created the sub in various
other ways.

Jeremy