Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Userforms and Macros
How do I get a message box to pop up when a file is opened?
Sub WorkBook_Activate() MsgBox "Any physician reporting ...." End Sub This code gets message box to the worksheet only if I hit run from the VB editor. I would like to warn the worksheet user as soon as they open the file. Thanks, Cinvic |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Userforms and Macros
You must place your code in ThisWorkbook's code, not in a Module
HTH -- AP "cinvic" a écrit dans le message de ... How do I get a message box to pop up when a file is opened? Sub WorkBook_Activate() MsgBox "Any physician reporting ...." End Sub This code gets message box to the worksheet only if I hit run from the VB editor. I would like to warn the worksheet user as soon as they open the file. Thanks, Cinvic |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Userforms and Macros
Thanks! It works.
"Ardus Petus" wrote: You must place your code in ThisWorkbook's code, not in a Module HTH -- AP "cinvic" a écrit dans le message de ... How do I get a message box to pop up when a file is opened? Sub WorkBook_Activate() MsgBox "Any physician reporting ...." End Sub This code gets message box to the worksheet only if I hit run from the VB editor. I would like to warn the worksheet user as soon as they open the file. Thanks, Cinvic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|