Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I conditionally format tab names in excel?
I am looking to automatically name the tabs in my spreadsheet based on a
name/data within that worksheet. Is this possible |
#2
|
|||
|
|||
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 -- HTH Bob Phillips "fullers" wrote in message ... I am looking to automatically name the tabs in my spreadsheet based on a name/data within that worksheet. Is this possible |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Import data from files with different names to EXCEL D'base. | Excel Discussion (Misc queries) | |||
how can I count distinct names in an excel list? | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
In Excel, how can you format for 4 digit years (MM/DD/YYYY)? | Excel Discussion (Misc queries) |