Is there a way to use a field link to rename a worksheet ?
 

I'm trying to find a way to make a worksheet name change according to a field
name . It would be nice to make the worksheet rename according to what is
typed in a specific field in a different worksheet. Anybody have any idea if
this can be done ?

Is there a way to use a field link to rename a worksheet ?
 

One way is to put this in the sheet module of the sheet where the cell to be
changed is located.
right click sheet tabview codecopy/paste thismodify to suitsave
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$H$1" Then Exit Sub
Sheet6.Name = Target
End Sub

--
Don Guillett
SalesAid Software

"John H." <John wrote in message
...
I'm trying to find a way to make a worksheet name change according to a
field
name . It would be nice to make the worksheet rename according to what is
typed in a specific field in a different worksheet. Anybody have any idea
if
this can be done ?

Is there a way to use a field link to rename a worksheet ?
 

well.....that completely lost me ?

"Don Guillett" wrote:

One way is to put this in the sheet module of the sheet where the cell to be
changed is located.
right click sheet tabview codecopy/paste thismodify to suitsave
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$H$1" Then Exit Sub
Sheet6.Name = Target
End Sub

--
Don Guillett
SalesAid Software

"John H." <John wrote in message
...
I'm trying to find a way to make a worksheet name change according to a
field
name . It would be nice to make the worksheet rename according to what is
typed in a specific field in a different worksheet. Anybody have any idea
if
this can be done ?

Is there a way to use a field link to rename a worksheet ?
 

Read it again, slowly. If you do it and change cell h1 sheet6 name will
change. Try it.

--
Don Guillett
SalesAid Software

"John H." wrote in message
...
well.....that completely lost me ?

"Don Guillett" wrote:

One way is to put this in the sheet module of the sheet where the cell to
be
changed is located.
right click sheet tabview codecopy/paste thismodify to suitsave
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$H$1" Then Exit Sub
Sheet6.Name = Target
End Sub

--
Don Guillett
SalesAid Software

"John H." <John wrote in message
...
I'm trying to find a way to make a worksheet name change according to a
field
name . It would be nice to make the worksheet rename according to what
is
typed in a specific field in a different worksheet. Anybody have any
idea
if
this can be done ?

Is there a way to use a field link to rename a worksheet ?
 

wow....thanks....it works !
i'm not familiar with Visual Basic....can you suggest a good book for me to
learn the language and code info....would love to learn it and make more use
of it myself.

thanks,
john h.

"Don Guillett" wrote:

Read it again, slowly. If you do it and change cell h1 sheet6 name will
change. Try it.

--
Don Guillett
SalesAid Software

"John H." wrote in message
...
well.....that completely lost me ?

"Don Guillett" wrote:

One way is to put this in the sheet module of the sheet where the cell to
be
changed is located.
right click sheet tabview codecopy/paste thismodify to suitsave
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$H$1" Then Exit Sub
Sheet6.Name = Target
End Sub

--
Don Guillett
SalesAid Software

"John H." <John wrote in message
...
I'm trying to find a way to make a worksheet name change according to a
field
name . It would be nice to make the worksheet rename according to what
is
typed in a specific field in a different worksheet. Anybody have any
idea
if
this can be done ?

Is there a way to use a field link to rename a worksheet ?
 

Google is your friend.

http://tinyurl.com/ya3zh3


--
Don Guillett
SalesAid Software

"John H." wrote in message
...
wow....thanks....it works !
i'm not familiar with Visual Basic....can you suggest a good book for me
to
learn the language and code info....would love to learn it and make more
use
of it myself.

thanks,
john h.

"Don Guillett" wrote:

Read it again, slowly. If you do it and change cell h1 sheet6 name will
change. Try it.

--
Don Guillett
SalesAid Software

"John H." wrote in message
...
well.....that completely lost me ?

"Don Guillett" wrote:

One way is to put this in the sheet module of the sheet where the cell
to
be
changed is located.
right click sheet tabview codecopy/paste thismodify to suitsave
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$H$1" Then Exit Sub
Sheet6.Name = Target
End Sub

--
Don Guillett
SalesAid Software

"John H." <John wrote in message
...
I'm trying to find a way to make a worksheet name change according
to a
field
name . It would be nice to make the worksheet rename according to
what
is
typed in a specific field in a different worksheet. Anybody have
any
idea
if
this can be done ?

Is there a way to use a field link to rename a worksheet ?
 

John

Don's answer involves worksheet event code.

Select the sheet tab and "View Code". Copy/paste the code into that sheet
module.

As written the code says..............

Whenever you type something into H1(field name cell) on the sheet, Sheet6 name
will change to that value.

NOTE: Sheet6 is Excel's VBA internal index name for the sheet and not
necessarily what you have named the sheet.

Currently you might have named it "yourname"

To find out which of your sheets is Sheet6 open VB Editor by hitting Alt + F11

CTRL + r to open Project Explorer.

Select your workbook/project and expand it.

Select Excel Objects to expand that.

You will get a list of the sheets with their index sheet numbers followed by the
actual name in parens.

Sheet6(yourname).

Change Don's Sheet6 in the code to the appropriate sheet index number if
necessary
Also change $H$1 to the appropriate field name cell.


Gord Dibben MS Excel MVP

On Thu, 4 Jan 2007 10:51:00 -0800, John H.
wrote:

well.....that completely lost me ?

"Don Guillett" wrote:

One way is to put this in the sheet module of the sheet where the cell to be
changed is located.
right click sheet tabview codecopy/paste thismodify to suitsave
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$H$1" Then Exit Sub
Sheet6.Name = Target
End Sub

--
Don Guillett
SalesAid Software

"John H." <John wrote in message
...
I'm trying to find a way to make a worksheet name change according to a
field
name . It would be nice to make the worksheet rename according to what is
typed in a specific field in a different worksheet. Anybody have any idea
if
this can be done ?