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 ?? |
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 |
Aaah, the joys of VB.
VB, I presumme ? |
All times are GMT +1. The time now is 02:12 AM. |
© 2024 MH Sub I, LLC dba Internet Brands