| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Msgbox on spreadsheet launch
Hi!
I want my message box to appear as soon as the excel sheet is opened, but I'm drawing a blank as to how to do it. Help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Msgbox on spreadsheet launch
Hi,
i the code for ThisWorkbook Private Sub Workbook_Open() MsgBox "my msg" End Sub J "Abi" wrote: Hi! I want my message box to appear as soon as the excel sheet is opened, but I'm drawing a blank as to how to do it. Help! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Msgbox on spreadsheet launch
See Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm You would want to use the workbook_open event. -- Regards, Tom Ogilvy "Abi" wrote in message ... Hi! I want my message box to appear as soon as the excel sheet is opened, but I'm drawing a blank as to how to do it. Help! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Msgbox on spreadsheet launch
thanks! The article helped greatly as I was missing a key step for the code.
"Tom Ogilvy" wrote: See Chip Pearson's page on events http://www.cpearson.com/excel/events.htm You would want to use the workbook_open event. -- Regards, Tom Ogilvy "Abi" wrote in message ... Hi! I want my message box to appear as soon as the excel sheet is opened, but I'm drawing a blank as to how to do it. Help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add-In Launch | Excel Discussion (Misc queries) | |||
| File won't launch | Excel Discussion (Misc queries) | |||
| Macro launch - Button vs Manual launch , has different results. | Excel Programming | |||
| How to launch excel spreadsheet and load xml file from cmd line? | Excel Programming | |||
| Using vb to launch a shortcut | Excel Programming | |||
Hybrid Mode
