+ Reply to Thread
Results 1 to 11 of 11

Change Only Certain Worksheet Names Using a List

Hybrid View

  1. #1
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    867

    Re: Change Only Certain Worksheet Names Using a List

    this code under INPUTS code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim new_name As String
    Dim ws As Worksheet
    
    If Target.Column = 2 And Target <> "" Then
        Set ws = Sheets(old_name)
        ws.Name = Target.Value
    End If
    End Sub
    
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column = 2 And Target <> "" Then
        old_name = Target.Value
    End If
    End Sub
    and this code in a module (insert Module)

    Option Explicit
    
    Public old_name As String
    Attached Files Attached Files
    Last edited by bulina2k; 02-03-2016 at 06:36 PM. Reason: attach the file
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

+ 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: 4
    Last Post: 07-24-2015, 08:33 AM
  2. List worksheet names in active worksheet By Excluding Specific Sheets
    By jagadeesh.rt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2014, 10:22 AM
  3. Macro to add worksheet - worksheet names change
    By PostID in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2013, 01:05 PM
  4. Change tab names from a list
    By RobertMika in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2011, 07:05 AM
  5. Replies: 5
    Last Post: 12-11-2010, 01:43 AM
  6. Replies: 0
    Last Post: 08-15-2008, 08:24 PM
  7. Code to List all worksheet names (tab names)
    By howard101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2007, 12:51 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