Skip to main content

Automatic message in excel

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

  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

Leave a Reply

Your email address will not be published. Required fields are marked *