Automatic message in excel

Sub Auto_Open()
Msgbox "Welcome to My Excel Sheet"
End Sub

Instructions:

1. Open an excel workbook
2. Press Alt+F11 to open VBA Editor
3. Double click on ThisWorkbook from Project Explorer
4. Copy the above code and Paste in the code window
5. Save the file as macro enabled workbook
6. Open the workbook to test it, it will Run a Macro Automatically. You should see a message box as shown above

know more click here