Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Names
Is it possible to name worksheets based on a formula?
I want sheet1 to be renamed to be whatever is in sheet1!A1 for instance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Names
Hi,
Right click the sheet tab, view code and paste this in Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next ActiveSheet.Name = Range("A1").Value End Sub Mike "veggies27" wrote: Is it possible to name worksheets based on a formula? I want sheet1 to be renamed to be whatever is in sheet1!A1 for instance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Names
Since it's based on a formula, then maybe using _calculate would be a better
event to use: Option Explicit Private Sub Worksheet_Calculate() On Error Resume Next Me.Name = Me.Range("a1").Value If Err.Number < 0 Then Beep MsgBox "Invalid name in A1!" Err.Clear End If On Error GoTo 0 End Sub Mike H wrote: Hi, Right click the sheet tab, view code and paste this in Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next ActiveSheet.Name = Range("A1").Value End Sub Mike "veggies27" wrote: Is it possible to name worksheets based on a formula? I want sheet1 to be renamed to be whatever is in sheet1!A1 for instance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Look up and match Vendor name in one cell of worksheet from list ofmultiple Vendor names in column of other worksheet | Excel Worksheet Functions | |||
Trying to list tab/worksheet names in a summary worksheet | Excel Discussion (Misc queries) | |||
Adding worksheet tab names to the first worksheet | Excel Discussion (Misc queries) | |||
Worksheet names | Excel Discussion (Misc queries) | |||
How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions |