Worksheet.Name property Archives

Learn

Excel Macro: Create a Table of Contents of Sheets

This Excel macro not only creates a table of contents at the beginning of the workbook, but it also adds hyperlinks. Get this VBA code now!

Learn

Excel Macro: Create a New Workbook for Each Sheet

Sometimes you may need to create a new workbook for each sheet, it seems very boring to do it manually, this macro can help you. Get it now!

Application.ScreenUpdating property Worksheet.Copy method Worksheet.Name property Workbook.Close method Workbook.Path property Workbook.SaveAs method For Each...Next statement

Learn

Excel Macro: Hide All Worksheets Except Active One

If the Workbook have many Worksheets and you need to hide all Worksheets except active one, you can use this Excel macro. Get it now!

Worksheet.Name property Worksheet.Visible property XlSheetVisibility enumeration For Each...Next statement

Docs

Worksheet.Name property

Returns or sets a String value that represents the object name. Syntax expression.Name expression A variable that represents a Worksheet object. Remarks […]

Worksheet.Name property