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+

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+

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+

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+