Excel VBA Run Code When Workbook Opened

This video looks at creating code in Excel VBA to run each time a workbook is opened. More specifically, we want this code to check and see if a sheet already exists in the workbook with today's date. If the sheet does not already exist we want our code to add a new sheet with today's date. In addition we want this new sheet to have formatted headers. If the sheet does already exist we want to display a message box that indicates that the sheet is already there.
Learn More about Excel VBA & Macros with this Book on Amazon:
amzn.to/3xnqT6R
Get a Microsoft Office 365 Personal Subscription with this Amazon link:
amzn.to/3aV9GtL
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
#ExcelVBAOnOpenEvent
#ExcelVBARunCodeOnOpen