View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeremy Jeremy is offline
external usenet poster
 
Posts: 1
Default 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