Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error message opening Excel file | Excel Discussion (Misc queries) | |||
How can I display a message when opening an Excel File? | Excel Discussion (Misc queries) | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
Display a message when opening Excel file | Setting up and Configuration of Excel | |||
when opening excel I receive a message that says file can't be fo. | Excel Discussion (Misc queries) |