hi guys
been trying the following in order to get a nice looking welcome message
Sub Auto_Open()
msgbox "Welcome to Excel"
End Sub
Yet it just doesnt open up whenever I open the file.
Any suggestion is well accepted.
Thanks in advance.
hi guys
been trying the following in order to get a nice looking welcome message
Sub Auto_Open()
msgbox "Welcome to Excel"
End Sub
Yet it just doesnt open up whenever I open the file.
Any suggestion is well accepted.
Thanks in advance.
In ThisWorkbook module
Private Sub Workbook_Open() MsgBox "Welcome to Excel" End Sub
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'