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.