How- Message box on opening excel file?

B

Buck247

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
 
J

Jeremy

Hi Buck
All I want is a message pop-up box saying "Blah Blah Blah" first thing,
when I open an excel file?
Click to expand...

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
 
Top