Welcome Message and Closing Message

Welcome Message

You can use auto_open to perform a task on opening a file. All you have to do just name your macro "auto_open".

Sub auto_open()

MsgBox "Welcome To ExcelChamps & Thanks for downloading this file."

End Sub

Closing Message

You can use close_open to perform a task on opening a file. All you have to do just name your macro "close_open".

Sub auto_close()

MsgBox "Bye Bye! Don't forget to check other cool stuff on excelchamps.com"

End Sub