Rename Worksheet without Selecting the sheet
 

Would this work?

Dim objWorksheet As Worksheet

For Each objWorksheet In ActiveWorkbook.Worksheets
objWorksheet.Name = "Your Name Here"
Next objWorksheet


JR_06062005 wrote:
Is there another way to rename a worksheet other than
ActiveWorkSheet.Name="New Name"?

I would like to rename a series of worksheets, but am not sure how to do
this without selecting each one.