Excel - Auto Updating Tab Names
05 November 2003, 10:02 PM
#1
Scooby Regular
Thread Starter
Join Date: Oct 2002
Location: ex UK [SE], now Sunshine State [QLD,AUS]
Posts: 565
Likes: 0
Received 1 Like
on
1 Post
Is there any way a tab (ie worksheet tab) can be linked to a particular cell.
So when the cell is updated, so is the tab name ??
So when the cell is updated, so is the tab name ??
05 November 2003, 10:32 PM
#2
Scooby Regular
Join Date: Jun 2002
Location: Perth, Western Australia
Posts: 1,866
Likes: 0
Received 0 Likes
on
0 Posts
You could try this bit of code.
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False 'stops change event repeating
'takes the value of cell A1 and renames the active sheet
ActiveWorkbook.ActiveSheet.Name = Cells(1, 1).Value
Application.EnableEvents = True
End Sub
HTH
Mark
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False 'stops change event repeating
'takes the value of cell A1 and renames the active sheet
ActiveWorkbook.ActiveSheet.Name = Cells(1, 1).Value
Application.EnableEvents = True
End Sub
HTH
Mark
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
An0n0m0us
Computer & Technology Related
0
28 September 2015 09:58 PM