Can I conditionally format tab names in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking to automatically name the tabs in my spreadsheet based on a
name/data within that worksheet. Is this possible
 
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

On Error GoTo wb_exit
Application.EnableEvents = False

With Target
If .Address = "$H$1" Then
Sh.Name = .Value
End If
End With

wb_exit:
Application.EnableEvents = True
End Sub


'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference the same cell based on tab name 1
Excel Highlighting duplicates 0
Condition Formatting for Tabs 1
Conditional formatting on a dynamic range - workaround 1
How to get range names to Apply across multiple tabs 1
Naming Tabs 1
Conditional formatting 2
Merging of multiple lists 1

Back
Top