Rename sheet based on cell in another sheet

[xbunsenx]

I am trying to rename a tab based on a cell value in another sheet. I would like the tab to be renamed after the cell is changed. I have searched and cannot find a solution. A1 is on Sheet2 and I want it to rename Sheet3. Any help is appreciated. This is what I tried, but obviously it does not work.

Private Sub Worksheet_change(ByVal Target As Range)
If Target.Address = Range("A1") Then
Sheet("Sheet3").Name = Range("A1").Value
End If
End Sub

 

[AkaTrouble]

rather than guess there is lots of detail on this link

if you cant workout how to use it then reply here and will try to help

i only suggest you read because there is some error checking on link which i think is good idea

https://www.mrexcel.com/forum/excel-questions/397308-rename-tab-based-cell-value-macro.html

 

[xbunsenx]

I could not get anything to work that was posted. I have to admit that I am not fluent in VBA code enough to know what is not working. I do want this process to work automatically and not in a macro. Thank you for any assistance.

 

[My Aswer Is This]

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Put this script in Sheet(2)

Private Sub Worksheet_change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
On Error GoTo M
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
Sheets(3).Name = Target.Value
End If
Exit Sub
M:
MsgBox "You entered an inproper sheet name or  " & vbNewLine & " Sheet name already exist"
End Sub

 

[xbunsenx]

My Answer,

It worked perfectly. I just had to add the ability to edit objects because the worksheets I am renaming are protected to prevent someone from accidentally altering a formula. Thank you for your help. I have learned something new.

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

My Answer,

It worked perfectly. I just had to add the ability to edit objects because the worksheets I am renaming are protected to prevent someone from accidentally altering a formula. Thank you for your help. I have learned something new.

 

[IREY]

Is it possible to do this same function with multiple worksheets and different cells?

 

[My Aswer Is This]

Is it possible to do this same function with multiple worksheets and different cells?

This is a very old posting from 2017
I suggest you make a new posting and be very specific
Give exact sheet names. Just be very specific with the details we need.
That stops us from having to come back and ask questions. I will see your new posting and try to help

 

[IREY]

I made a post

Rename Multiple sheets Based on Cells in Mastersheet

Hi, Im having some trouble figuring out how to do this but i would like to rename multiple sheets based off what is inside cells in the master sheet. I would like the sheet names to update automatically when the cells are updated. Currently this is what ive tried using but it only works on...

www.mrexcel.com