rename specific worksheets

[reza_doang]

Hi -

everyday i always have 3 sheet (sheet1, sheet2 and sheet3) and need to copy to new workbook.
but before that, i need to rename it with
- sheet1 = backlog approval
- sheet2 = backlog release
- sheet3 = backlog pr

instead using manual effort, can you please help to create vba macro to run automatic.

thanks in advance

 

[Peter_SSs]

See if this helps for the renaming.

Sub Rename_Sheets()
  On Error Resume Next
  Sheets("sheet1").Name = "backlog approval"
  Sheets("sheet2").Name = "backlog release"
  Sheets("sheet3").Name = "backlog pr"
  On Error GoTo 0
End Sub

 

[reza_doang]

See if this helps for the renaming.

Sub Rename_Sheets()
  On Error Resume Next
  Sheets("sheet1").Name = "backlog approval"
  Sheets("sheet2").Name = "backlog release"
  Sheets("sheet3").Name = "backlog pr"
  On Error GoTo 0
End Sub

thanks Peter for quick response, and working like a charm

 

[Peter_SSs]

thanks Peter for quick response, and working like a charm

You're welcome. Thanks for the confirmation.