Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom message at opening or closing of file
Can a pop up message be displayed at the opening or closing of an excel file?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom message at opening or closing of 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom message at opening or closing of 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Message box upon opening file | Excel Discussion (Misc queries) | |||
Prompt Message when opening a file | Excel Worksheet Functions | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
Message Upon Opening File | Excel Discussion (Misc queries) | |||
Unexpected error message on closing an Excel file | Excel Discussion (Misc queries) |