Custom message at opening or closing of file

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel spreadsheets opening at top instead of bottom. 4
Excel Unlink open excel files 2
Project Gallery displays only obsolete files 1
Thunderbird problem 1
File won't open 1
Custom Messages in Excel 3
Excel Providing user message when RED X clicked & properly closing application. 2
file format or file extension is not valid...error message 0

Back
Top