In the MVB windoe I go to to file<save master template and the same window
appears with the code i copied and pasted. I close the windows using the red
X in the corner. When i reopen The work book nothing has changed.

I thank you for your help.
--
Thanks in advance.

Scoober


"Jacob Skaria" wrote:

Saving the workbook will save the code.

--Exit the excel application and re-open excel..open the saved workbook and
try.

--Make sure no other code exists in the code pane .. Sheet tabView code

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


"Scoober" wrote:

Thank you Jacob. I have completed all your steps, but nothing happens. I hit
enter, and the curser travels down the page but does not enter anything. I
close the text box to leave the Tab and nothing happens.

I copied and pasted what you sent to me in the box that opens after i click
view code. The code is pasted but then nothing happens. There is no 'enter'
or 'save' button that i can see.

How do i enter or get the box to accept what i have copied and pasted in it.??

I am at a complete loss.
--
Thanks in advance.

Scoober


"Jacob Skaria" wrote:

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

Hi "Scoober"

Let us redo the whole thing again. Fine here we go.

--Close your existing excel application and all workbooks.
--Reopen Excel and currently we are in a new workbook.
--Check menu toolsMacrosSecurity and make sure the security level is set
to low
--Right click the Sheet tabView code and on the right side you can see the
code pane with 2 drop downs . Paste the below code

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

--Dont worry about saving the code. Get back to workbook.
--Try entering a text string in cell A1. (Make sure you dont enter
characters like \/ etc; which are not acceptable in sheet names..)
--Try and feedback..

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


"Scoober" wrote:

In the MVB windoe I go to to file<save master template and the same window
appears with the code i copied and pasted. I close the windows using the red
X in the corner. When i reopen The work book nothing has changed.

I thank you for your help.
--
Thanks in advance.

Scoober


"Jacob Skaria" wrote:

Saving the workbook will save the code.

--Exit the excel application and re-open excel..open the saved workbook and
try.

--Make sure no other code exists in the code pane .. Sheet tabView code

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


"Scoober" wrote:

Thank you Jacob. I have completed all your steps, but nothing happens. I hit
enter, and the curser travels down the page but does not enter anything. I
close the text box to leave the Tab and nothing happens.

I copied and pasted what you sent to me in the box that opens after i click
view code. The code is pasted but then nothing happens. There is no 'enter'
or 'save' button that i can see.

How do i enter or get the box to accept what i have copied and pasted in it.??

I am at a complete loss.
--
Thanks in advance.

Scoober


"Jacob Skaria" wrote:

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

I did what you suggested and started from a completely blank worksheet and it
work! :)

But when i go back to the worksheet i am working on it does not work. Does
it matter that the cell i am trying to copy the name from (b5) is merged?

i am using this forumla

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


--
Thanks in advance.

Scoober


"Jacob Skaria" wrote:

Hi "Scoober"

Let us redo the whole thing again. Fine here we go.

--Close your existing excel application and all workbooks.
--Reopen Excel and currently we are in a new workbook.
--Check menu toolsMacrosSecurity and make sure the security level is set
to low
--Right click the Sheet tabView code and on the right side you can see the
code pane with 2 drop downs . Paste the below code

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

--Dont worry about saving the code. Get back to workbook.
--Try entering a text string in cell A1. (Make sure you dont enter
characters like \/ etc; which are not acceptable in sheet names..)
--Try and feedback..

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


"Scoober" wrote:

In the MVB windoe I go to to file<save master template and the same window
appears with the code i copied and pasted. I close the windows using the red
X in the corner. When i reopen The work book nothing has changed.

I thank you for your help.
--
Thanks in advance.

Scoober


"Jacob Skaria" wrote:

Saving the workbook will save the code.

--Exit the excel application and re-open excel..open the saved workbook and
try.

--Make sure no other code exists in the code pane .. Sheet tabView code

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


"Scoober" wrote:

Thank you Jacob. I have completed all your steps, but nothing happens. I hit
enter, and the curser travels down the page but does not enter anything. I
close the text box to leave the Tab and nothing happens.

I copied and pasted what you sent to me in the box that opens after i click
view code. The code is pasted but then nothing happens. There is no 'enter'
or 'save' button that i can see.

How do i enter or get the box to accept what i have copied and pasted in it.??

I am at a complete loss.
--
Thanks in advance.

Scoober


"Jacob Skaria" wrote:

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