Can a cell be used to name a worksheet.

e.g In A1 Joe Bloggs is written, is there formula that can name the
worksheet's Tab Joe Bloggs?
--
Thanks in advance.

Scoober

Hi, take a look at Mcgimpsey web

http://www.mcgimpsey.com/excel/event...efromcell.html

if this helps please click yes, thanks


"Scoober" wrote:

Can a cell be used to name a worksheet.

e.g In A1 Joe Bloggs is written, is there formula that can name the
worksheet's Tab Joe Bloggs?
--
Thanks in advance.

Scoober

dI'm not paticularly good with LX and did not understand a worg that that
link said.

I take it it is a little more than simply adding a foruula somewhere?
--


Scoober


"Eduardo" wrote:

Hi, take a look at Mcgimpsey web

http://www.mcgimpsey.com/excel/event...efromcell.html

if this helps please click yes, thanks


"Scoober" wrote:

Can a cell be used to name a worksheet.

e.g In A1 Joe Bloggs is written, is there formula that can name the
worksheet's Tab Joe Bloggs?
--
Thanks in advance.

Scoober

Hi,
in order to get the tab to be named according to a name entered in a cell
you need a VBA
Mc gimpsey tell you how to copy the code provided open the link from the
first paragraph tha says "Worksheet code module", it explain step by step
what to do

"Scoober" wrote:

dI'm not paticularly good with LX and did not understand a worg that that
link said.

I take it it is a little more than simply adding a foruula somewhere?
--


Scoober


"Eduardo" wrote:

Hi, take a look at Mcgimpsey web

http://www.mcgimpsey.com/excel/event...efromcell.html

if this helps please click yes, thanks


"Scoober" wrote:

Can a cell be used to name a worksheet.

e.g In A1 Joe Bloggs is written, is there formula that can name the
worksheet's Tab Joe Bloggs?
--
Thanks in advance.

Scoober

What is a VBA?

I have opened a tab by right clicking it and clicking view Tab and C&P'd

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Const sNAMECELL As String = "A1"
Const sERROR As String = "Invalid worksheet name in cell "
Dim sSheetName As String

But when i hit enter nothing happens?

Scoober


"Eduardo" wrote:

Hi,
in order to get the tab to be named according to a name entered in a cell
you need a VBA
Mc gimpsey tell you how to copy the code provided open the link from the
first paragraph tha says "Worksheet code module", it explain step by step
what to do

"Scoober" wrote:

dI'm not paticularly good with LX and did not understand a worg that that
link said.

I take it it is a little more than simply adding a foruula somewhere?
--


Scoober


"Eduardo" wrote:

Hi, take a look at Mcgimpsey web

http://www.mcgimpsey.com/excel/event...efromcell.html

if this helps please click yes, thanks


"Scoober" wrote:

Can a cell be used to name a worksheet.

e.g In A1 Joe Bloggs is written, is there formula that can name the
worksheet's Tab Joe Bloggs?
--
Thanks in advance.

Scoober

This is what Jacob posted...................

Fine. If you are looking to change the sheet tab name as soon as you type in
a text in cell A1. try the below code. Set the Security level to low/medium
in (Tools|Macro|Security). Right click SheettabView code and paste the
below
code.

Change the text in cell A1 and see

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Count = 1 And Target.Address = "$A$1" Then
If Trim(Target.Text) < "" Then Me.Name = Trim(Range("A1"))
End If
Application.EnableEvents = True
End Sub

.................................................. .......

After copying and pasting the code into the sheet module, Alt + q to return
to the worksheet view.

Type something in A1 and see the sheet name change.


Gord Dibben MS Excel MVP

On Tue, 4 Aug 2009 05:48:01 -0700, Scoober
wrote:

What is a VBA?

I have opened a tab by right clicking it and clicking view Tab and C&P'd

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Const sNAMECELL As String = "A1"
Const sERROR As String = "Invalid worksheet name in cell "
Dim sSheetName As String

But when i hit enter nothing happens?

Scoober


"Eduardo" wrote:

Hi,
in order to get the tab to be named according to a name entered in a cell
you need a VBA
Mc gimpsey tell you how to copy the code provided open the link from the
first paragraph tha says "Worksheet code module", it explain step by step
what to do

"Scoober" wrote:

dI'm not paticularly good with LX and did not understand a worg that that
link said.

I take it it is a little more than simply adding a foruula somewhere?
--


Scoober


"Eduardo" wrote:

Hi, take a look at Mcgimpsey web

http://www.mcgimpsey.com/excel/event...efromcell.html

if this helps please click yes, thanks


"Scoober" wrote:

Can a cell be used to name a worksheet.

e.g In A1 Joe Bloggs is written, is there formula that can name the
worksheet's Tab Joe Bloggs?
--
Thanks in advance.

Scoober

Formula cannot name a sheet. You will have to use a macro..

Sub Macro()
ActiveSheet.Name = Range("A1")
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Scoober" wrote:

dI'm not paticularly good with LX and did not understand a worg that that
link said.

I take it it is a little more than simply adding a foruula somewhere?
--


Scoober


"Eduardo" wrote:

Hi, take a look at Mcgimpsey web

http://www.mcgimpsey.com/excel/event...efromcell.html

if this helps please click yes, thanks


"Scoober" wrote:

Can a cell be used to name a worksheet.

e.g In A1 Joe Bloggs is written, is there formula that can name the
worksheet's Tab Joe Bloggs?
--
Thanks in advance.

Scoober

I right mouse click the tab I want named. Then I click view code. The I copy
and paste

Sub Macro()
ActiveSheet.Name = Range("B7")
End Sub

I push enter and nothing happens?
--
Thanks in advance.

Scoober


"Jacob Skaria" wrote:

Formula cannot name a sheet. You will have to use a macro..

Sub Macro()
ActiveSheet.Name = Range("A1")
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Scoober" wrote:

dI'm not paticularly good with LX and did not understand a worg that that
link said.

I take it it is a little more than simply adding a foruula somewhere?
--


Scoober


"Eduardo" wrote:

Hi, take a look at Mcgimpsey web

http://www.mcgimpsey.com/excel/event...efromcell.html

if this helps please click yes, thanks


"Scoober" wrote:

Can a cell be used to name a worksheet.

e.g In A1 Joe Bloggs is written, is there formula that can name the
worksheet's Tab Joe Bloggs?
--
Thanks in advance.

Scoober

Fine. If you are looking to change the sheet tab name as soon as you type in
a text in cell A1. try the below code. Set the Security level to low/medium
in (Tools|Macro|Security). Right click SheettabView code and paste the below
code.

Change the text in cell A1 and see

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Count = 1 And Target.Address = "$A$1" Then
If Trim(Target.Text) < "" Then Me.Name = Trim(Range("A1"))
End If
Application.EnableEvents = True
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Scoober" wrote:

I right mouse click the tab I want named. Then I click view code. The I copy
and paste

Sub Macro()
ActiveSheet.Name = Range("B7")
End Sub

I push enter and nothing happens?
--
Thanks in advance.

Scoober


"Jacob Skaria" wrote:

Formula cannot name a sheet. You will have to use a macro..

Sub Macro()
ActiveSheet.Name = Range("A1")
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Scoober" wrote:

dI'm not paticularly good with LX and did not understand a worg that that
link said.

I take it it is a little more than simply adding a foruula somewhere?
--


Scoober


"Eduardo" wrote:

Hi, take a look at Mcgimpsey web

http://www.mcgimpsey.com/excel/event...efromcell.html

if this helps please click yes, thanks


"Scoober" wrote:

Can a cell be used to name a worksheet.

e.g In A1 Joe Bloggs is written, is there formula that can name the
worksheet's Tab Joe Bloggs?
--
Thanks in advance.

Scoober