Message Box Please

[Roopen]

Hi,

Would anyone know of a macro that would enable me to see a pop-up appear as soon as a spreadsheet is opened?

I want the message box to read:

"Please note that 3% Wage Increases have been added to July Forecasts!"



As always, any help gratefully received

 

[JamesW]

Hi,

Try:

Private Sub Workbook_Open()
    MsgBox "Please note that 3% Wage Increases have been added to July Forecasts!"
End Sub

 

[VoG]

Try in the ThisWorkbook module

Private Sub Workbook_Open()
MsgBox "Please note that 3% Wage Increases have been added to July Forecasts!", vbInformation
End Sub

 

[Roopen]

You guys are awesome... Many thanks for such a speedy response !!!