Excel Tutorials | Workbook Macro Code

Welcome Message

Sub auto_open() MsgBox _ “Welcome To xlsxtemplates & Thanks for downloading this file.” End Sub Welcome Message in excel macro code.  You can use auto_open

Read More »

Active Workbook in an Email

Sub Send_Mail() Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject(“Outlook.Application”) Set OutMail = OutApp.CreateItem(0) With OutMail .to = “Sales@FrontLinePaper.com” .Subject =

Read More »

Closing Message

Sub auto_close() MsgBox “Bye Bye! Don’t forget to check other cool stuff on xlsxtemplates.com” End Sub Closing Message Excel macro code:  You can use close_open

Read More »