Can a pop up message be displayed at the opening or closing of an excel file?

place the code in ThisWorkbook tab in the VBA windown
--
If this reply was helpful, please indicate that your question has been
answered to help others find anwsers to similar questions.

www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009


"Patty" wrote:

Can a pop up message be displayed at the opening or closing of an excel file?

Use a user form.
Use this code

Private Sub Workbook_Open()

Userform1.Show True

End Sub



or, if you want a text message only use this code

Private Sub Workbook_Open()



Sheets("Welcome").Select
Rows("2:6").Select
Selection.EntireRow.Hidden = True
Range("A1").Select

MsgBox "Line 1" & vbNewLine & _
"Line 2" & vbNewLine & _
"Line 3" & vbNewLine & _
"Line 4"
End Sub


--
If this reply was helpful, please indicate that your question has been
answered to help others find anwsers to similar questions.

www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009


"Patty" wrote:

Can a pop up message be displayed at the opening or closing of an excel file?