Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi - I'd like to create a message (on a form, I guess) that automatically is
opened as soon as a specific file is opened. I was hoping someone could provide me with suggestions on how to do this or even the code they think would be needed to do this. Thanks, Robert |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can use a procedure named Auto_open in a general module:
Option Explicit Sub Auto_Open() msgbox "Hi from this here workbook!" end sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Linking to specific cells in pivot table wrote: Hi - I'd like to create a message (on a form, I guess) that automatically is opened as soon as a specific file is opened. I was hoping someone could provide me with suggestions on how to do this or even the code they think would be needed to do this. Thanks, Robert -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel file opens and opens and opens | Excel Discussion (Misc queries) | |||
how can I create a pop-up message whenever a workbook is opened? | Excel Discussion (Misc queries) | |||
message box when file is opened | Excel Worksheet Functions | |||
Display a message when a file is opened. | New Users to Excel | |||
Message when workbook is opened | Excel Programming |