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

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

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