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

Department Email {Outlook Quick Steps Series}

Outlook gives you the ability to create memorized actions called Quick Steps.  One helpful Quick Step you can create is a standard email to send to all recipients of your department.  Using this Quick Step, you can quickly email your entire department keeping everyone informed. Think of Quick Steps as a toolbox that you add tools to over time.  Leverage & Lean is here to help fill your Outlook toolbox!

Word Create AutoText

If you find yourself typing the same thing over and over again take a moment to create AutoText in Word! AutoText can be a few words or entire sentences you decide. AutoText makes typing more efficient and can help you get more done in Word.

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!

Copyright © 2019 Leverage & Lean – Uptown Style WordPress theme by GoDaddy