Worksheet names with macro buttons The Create List of Sheet Name utility makes it easy for you to create a list of all worksheet names of the active workbook in a new worksheet, which contains hyperlinks or macro buttons for quickly navigate to other worksheets Click toIn Excel, you can define a range name, and then apply a formula to list all sheet names from current workbook, please do with following steps 1 Go to click Formula > Name Manager, see screenshot 2 In the Name Manager dialog box, click New button, see screenshot 321/6/19 Step 1 Drag "Excel Application Scope" activity into the designer panel and supply the following values into the activity's properties panel WorkbookPath "Sample_Excelxlsx" (String type) Workbook myWorkbook (WorkbookApplication type) Step 2
Insert Sheet Name In Cell Easy 3 Methods To Return The Worksheet Name
