Results 1 to 4 of 4

Thread: rename specific worksheets
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2010
    Posts
    185
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default rename specific worksheets

    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

  2. #2
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,976
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    21 Thread(s)

    Default Re: rename specific worksheets

    See if this helps for the renaming.
    Code:
    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
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  3. #3
    Board Regular
    Join Date
    May 2010
    Posts
    185
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: rename specific worksheets

    Quote Originally Posted by Peter_SSs View Post
    See if this helps for the renaming.
    Code:
    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

  4. #4
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,976
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    21 Thread(s)

    Default Re: rename specific worksheets

    Quote Originally Posted by reza_doang View Post
    thanks Peter for quick response, and working like a charm
    You're welcome. Thanks for the confirmation.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •