software

I would like to change the default worksheet name of Sheet1 to 0001 to
continue 0002, 0003 and so forth. Is there an option where I can change that
name?

Thanks - I should've worded my question differently. I can rename one sheet
at a time, but I have 100 sheets that I need to name 0001, 0002, 0003...
0100. I changed the default amount of sheets to 100, but I would like for
the sheets to automatically be named 0001, 0002, etc.

Thanks again,
Amanda

quot;B. R.Ramachandranquot; wrote:

gt; Hi,
gt;
gt; Double-click on the sheet name (the name gets highlighted), and type in the
gt; new name.
gt;
gt; Regards,
gt; B. R. Ramachandran
gt;
gt; quot;Amanda097quot; wrote:
gt;
gt; gt; I would like to change the default worksheet name of Sheet1 to 0001 to
gt; gt; continue 0002, 0003 and so forth. Is there an option where I can change that
gt; gt; name?

One way:

Run this macro to change the name of the 100 sheets. Delete the macro if
desired, then save the workbook as a template.Public Sub RenameWorksheets()
Dim i As Long
For i = 1 to Worksheets.Count
Worksheets(i).Name = Format(i, quot;0000quot;)
Next i
End Sub

You can make this the default template by saving the template as
quot;Book.xltquot; in your XLStart folder.

In article gt;,
Amanda097 gt; wrote:

gt; Thanks - I should've worded my question differently. I can rename one sheet
gt; at a time, but I have 100 sheets that I need to name 0001, 0002, 0003...
gt; 0100. I changed the default amount of sheets to 100, but I would like for
gt; the sheets to automatically be named 0001, 0002, etc.
gt;
gt; Thanks again,
gt; Amanda
gt;
gt; quot;B. R.Ramachandranquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; Double-click on the sheet name (the name gets highlighted), and type in the
gt; gt; new name.
gt; gt;
gt; gt; Regards,
gt; gt; B. R. Ramachandran
gt; gt;
gt; gt; quot;Amanda097quot; wrote:
gt; gt;
gt; gt; gt; I would like to change the default worksheet name of Sheet1 to 0001 to
gt; gt; gt; continue 0002, 0003 and so forth. Is there an option where I can change
gt; gt; gt; that
gt; gt; gt; name?

Thank you so much - that worked beautifully!!

quot;JE McGimpseyquot; wrote:

gt; One way:
gt;
gt; Run this macro to change the name of the 100 sheets. Delete the macro if
gt; desired, then save the workbook as a template.
gt;
gt;
gt; Public Sub RenameWorksheets()
gt; Dim i As Long
gt; For i = 1 to Worksheets.Count
gt; Worksheets(i).Name = Format(i, quot;0000quot;)
gt; Next i
gt; End Sub
gt;
gt; You can make this the default template by saving the template as
gt; quot;Book.xltquot; in your XLStart folder.
gt;
gt; In article gt;,
gt; Amanda097 gt; wrote:
gt;
gt; gt; Thanks - I should've worded my question differently. I can rename one sheet
gt; gt; at a time, but I have 100 sheets that I need to name 0001, 0002, 0003...
gt; gt; 0100. I changed the default amount of sheets to 100, but I would like for
gt; gt; the sheets to automatically be named 0001, 0002, etc.
gt; gt;
gt; gt; Thanks again,
gt; gt; Amanda
gt; gt;
gt; gt; quot;B. R.Ramachandranquot; wrote:
gt; gt;
gt; gt; gt; Hi,
gt; gt; gt;
gt; gt; gt; Double-click on the sheet name (the name gets highlighted), and type in the
gt; gt; gt; new name.
gt; gt; gt;
gt; gt; gt; Regards,
gt; gt; gt; B. R. Ramachandran
gt; gt; gt;
gt; gt; gt; quot;Amanda097quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I would like to change the default worksheet name of Sheet1 to 0001 to
gt; gt; gt; gt; continue 0002, 0003 and so forth. Is there an option where I can change
gt; gt; gt; gt; that
gt; gt; gt; gt; name?
gt;

Can I also use this type of Macro to name the sheets January, February,
March, etc? I'm not familiar with macros.

quot;JE McGimpseyquot; wrote:

gt; One way:
gt;
gt; Run this macro to change the name of the 100 sheets. Delete the macro if
gt; desired, then save the workbook as a template.
gt;
gt;
gt; Public Sub RenameWorksheets()
gt; Dim i As Long
gt; For i = 1 to Worksheets.Count
gt; Worksheets(i).Name = Format(i, quot;0000quot;)
gt; Next i
gt; End Sub
gt;
gt; You can make this the default template by saving the template as
gt; quot;Book.xltquot; in your XLStart folder.
gt;
gt; In article gt;,
gt; Amanda097 gt; wrote:
gt;
gt; gt; Thanks - I should've worded my question differently. I can rename one sheet
gt; gt; at a time, but I have 100 sheets that I need to name 0001, 0002, 0003...
gt; gt; 0100. I changed the default amount of sheets to 100, but I would like for
gt; gt; the sheets to automatically be named 0001, 0002, etc.
gt; gt;
gt; gt; Thanks again,
gt; gt; Amanda
gt; gt;
gt; gt; quot;B. R.Ramachandranquot; wrote:
gt; gt;
gt; gt; gt; Hi,
gt; gt; gt;
gt; gt; gt; Double-click on the sheet name (the name gets highlighted), and type in the
gt; gt; gt; new name.
gt; gt; gt;
gt; gt; gt; Regards,
gt; gt; gt; B. R. Ramachandran
gt; gt; gt;
gt; gt; gt; quot;Amanda097quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I would like to change the default worksheet name of Sheet1 to 0001 to
gt; gt; gt; gt; continue 0002, 0003 and so forth. Is there an option where I can change
gt; gt; gt; gt; that
gt; gt; gt; gt; name?
gt;

One way:

Public Sub RenameWorksheets()
Dim i As Long
For i = 1 To Worksheets.Count
Worksheets(i).Name = Format(DateSerial(0, i, 1), quot;mmmmquot;)
Next i
End Sub

Note that this will only work for 12 sheets or less, since sheets can't
have the same name as another sheet.

In article gt;,
Amanda097 gt; wrote:

gt; Can I also use this type of Macro to name the sheets January, February,
gt; March, etc? I'm not familiar with macros.

Thanks again for being so helpful!!

quot;JE McGimpseyquot; wrote:

gt; One way:
gt;
gt; Public Sub RenameWorksheets()
gt; Dim i As Long
gt; For i = 1 To Worksheets.Count
gt; Worksheets(i).Name = Format(DateSerial(0, i, 1), quot;mmmmquot;)
gt; Next i
gt; End Sub
gt;
gt; Note that this will only work for 12 sheets or less, since sheets can't
gt; have the same name as another sheet.
gt;
gt;
gt;
gt;
gt; In article gt;,
gt; Amanda097 gt; wrote:
gt;
gt; gt; Can I also use this type of Macro to name the sheets January, February,
gt; gt; March, etc? I'm not familiar with macros.
gt;