Excel New Worksheet when Opening [Macro Recorder]

Get started using Excel VBA by allowing the Macro Recorder to generate the code for you! This tutorial will show you how to record a macro in Excel that will create a new Worksheet. With some additional steps you can have this VBA code fire every time the Workbook opens. In Visual Basic you need to paste the generated code in ThisWorkbook within a Sub titled Workbook_Open. When saving Visual Basic you will be prompted to save the current Workbook as a macro enabled (*.xlsm) Next time you open the Workbook a new Worksheet will be created!

See How

Watch this video to see how to do this on your computer.

Read How

Follow this step by step guide to do this on your computer. Read How PDF Button

Search for more Tutorials

Recent Tutorials

Looking for more?

Subscribe as an Insider to receive additional rights.

Contact Us

Looking to improve your computer processes?
Leverage & Lean is here to help!

Powered By MemberPress WooCommerce Plus Integration

Free Macro

Start creating Less Clicks, More Results today!