+ Reply to Thread
Results 1 to 2 of 2

Rename Sheets Names automatically

Hybrid View

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Rename Sheets Names automatically

    hi,
    i am more then 10 sheets on my workbook with different names and changes name accordingly my needs.


    but two sheets name never changes,
    1 = "sheet1"
    2 = "sheet2"

    i want to rename both sheets when i switch to sheet
    for example

    if i activate the "sheet2" then i goes to rename auto with "sheet1" and "sheet1" goes to rename "sheet2"

    thank you in advannce
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Rename Sheets Names automatically

    5B:
    Private Sub Workbook_SheetActivate(ByVal Sh As Object)
      If Sh.Name = "Sheet2" Then
         Sh.Name = "ZZZ"
         Sheets("Sheet1").Name = "Sheet2"
         Sh.Name = "Sheet1"
      End If
    End Sub
    Attached Files Attached Files
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 10-06-2014, 01:03 AM
  2. Replies: 2
    Last Post: 11-21-2013, 02:43 PM
  3. Replies: 1
    Last Post: 08-23-2013, 09:01 AM
  4. Rename Automatically Different Sheets
    By rami10 in forum Excel General
    Replies: 1
    Last Post: 04-25-2013, 11:33 AM
  5. Replies: 7
    Last Post: 11-25-2012, 01:24 AM
  6. rename sheets according to column A names.
    By fatalcore in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-03-2011, 03:14 PM
  7. [SOLVED] Rename Multiple Sheets from a List of Available Names
    By prkhan56 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-04-2005, 02:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1