ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Display a message when opening Excel file (https://www.excelbanter.com/setting-up-configuration-excel/39718-display-message-when-opening-excel-file.html)

Julie

Display a message when opening Excel file
 
Is there a way to display a message upon opening a particular Excel File?

Thank You

Bob Phillips

Private Sub Workbook_Open()
MsgBox "hello"
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code



--
HTH

Bob Phillips

"Julie" wrote in message
...
Is there a way to display a message upon opening a particular Excel File?

Thank You





All times are GMT +1. The time now is 09:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com