Excel New Worksheet when Opening [Macro Recorder]

Share on facebook
Share on twitter
Share on linkedin
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!

Leverage & Lean

Is focused on improving computer processes by Leveraging programming and applying Lean principles. It is our goal to make you more efficient and effective on your computer producing “Less Clicks and More Results!”