| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link a sheet name to a cell
Is there a way to rename a sheet depending on the values entered in a cell?
For example: I have a workbook with multiple sheets. If someone were to type a string (text) into a cell, can it rename a different sheet within the same notebook? -- MCP, MCDST, CompTia A+ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link a sheet name to a cell
Sorry, I need this to be done without macros. Is this possible???
-- MCP, MCDST, CompTia A+ "Kirk Christian" wrote: Is there a way to rename a sheet depending on the values entered in a cell? For example: I have a workbook with multiple sheets. If someone were to type a string (text) into a cell, can it rename a different sheet within the same notebook? -- MCP, MCDST, CompTia A+ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link a sheet name to a cell
Sorry, I need this to be done without macros. Is this possible???
No But should you choose to change your mind, here's a macro Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo getmeout If Target.Address < "$A$1" Then Exit Sub Sheets(3).Name = Target.Value Exit Sub getmeout: MsgBox Target.Value & " Is an illegal worksheet name" End Sub Mike "Kirk Christian" wrote: Sorry, I need this to be done without macros. Is this possible??? -- MCP, MCDST, CompTia A+ "Kirk Christian" wrote: Is there a way to rename a sheet depending on the values entered in a cell? For example: I have a workbook with multiple sheets. If someone were to type a string (text) into a cell, can it rename a different sheet within the same notebook? -- MCP, MCDST, CompTia A+ |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link a sheet name to a cell
Well I thank you for your quick response.
This is for an assignment at school, so I am not able to use macros. But I will be using this on other workbooks; this is too nice of a trick to miss! Thanks! -- MCP, MCDST, CompTia A+ "Mike H" wrote: Sorry, I need this to be done without macros. Is this possible??? No But should you choose to change your mind, here's a macro Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo getmeout If Target.Address < "$A$1" Then Exit Sub Sheets(3).Name = Target.Value Exit Sub getmeout: MsgBox Target.Value & " Is an illegal worksheet name" End Sub Mike "Kirk Christian" wrote: Sorry, I need this to be done without macros. Is this possible??? -- MCP, MCDST, CompTia A+ "Kirk Christian" wrote: Is there a way to rename a sheet depending on the values entered in a cell? For example: I have a workbook with multiple sheets. If someone were to type a string (text) into a cell, can it rename a different sheet within the same notebook? -- MCP, MCDST, CompTia A+ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i link one sheet to another sheets cell of the same workboo | Excel Discussion (Misc queries) | |||
| Cell External Link in a sheet | Excel Discussion (Misc queries) | |||
| Can I link the name of a sheet to a cell within the same sheet? | Excel Discussion (Misc queries) | |||
| How do I link data from a cell on one spread sheet to another? | Excel Worksheet Functions | |||
| link cell from one sheet to another within the same workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
