Using sheet codenames in Microsoft Excel VBA. A common way to reference Excel worksheets in Visual Basic for Applications (VBA) is to use their tab name. However, this alternative method has several advantages - and one disadvantage! Lesson 3 on Excel macros (VBA): The Properties Window in the VBE of Excel. Note: Print this page, open Excel and a open a new workbook. Use ALT/F11 to open the Visual Basic Editor as you learned in lesson 1. The Properties window shows you the properties of the component that is selected in the Project Window (single click). Copy a worksheet multiple times and rename them with custom names by using Kutools for Excel Maybe the above VBA codes are difficult for you to apply, here, I will introduce an easy tool- Kutools for Excel , with its Create Sequence Worksheets utility, you can achieve this task without any effort. I only know the standard vba for rename excel sheet which is renaming excel sheet by the sheet content. Sub Test() Dim WS As Worksheet For Each WS In Sheets WS.Name = WS.Range("A5") Next WS End Sub Jun 04, 2019 · 1) The following code renames an excel worksheet in VBScript. To rename an excel sheet we need to open the excel file, rename the sheets, save and close it. Now we can start coding to open and rename the first excel sheet from "Sheet1" to "NewName". Jul 16, 2015 · If you don’t specify either Before or After, Microsoft Excel creates a new workbook that contains the copied sheet.. Example 1 – Copy worksheet in the same workbook. The below example copies “Sheet2” to the end of the worksheets, and rename it as “new worksheet”.