I would like to see to abilty to dynamically label the sheets in a workbork.
For Example, the project I execute bi-weeky has one sheet per day of the
week. If I could set this up to reference a cell or formula like I do the
date that is inserted at the top of the page. that way. This could be done
maybe as a Virtual Label so that the sheet that says it is May 15 would
always stay Sheet 2 so my hyperlink would not get broken by renaming the
sheet as that is currently te only way I could get it label.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

Norman,

You can have a Worksheet that's name is based on the contents of a cell.

Check out the Excel VBA toolbox on my website for a snippet of code that
allows you to do that.

HTH

Neil
www.nwarwick.co.uk

"Norman" wrote:

I would like to see to abilty to dynamically label the sheets in a workbork.
For Example, the project I execute bi-weeky has one sheet per day of the
week. If I could set this up to reference a cell or formula like I do the
date that is inserted at the top of the page. that way. This could be done
maybe as a Virtual Label so that the sheet that says it is May 15 would
always stay Sheet 2 so my hyperlink would not get broken by renaming the
sheet as that is currently te only way I could get it label.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

Your code crashes if you try to name a sheet the same name as an existing
sheet or if you try to rename the sheet to a name that is too long, or if you
try to rename it to "history". That and I think the Op was suggesting the
this be an internal feature of xl, not a macro...

--
HTH...

Jim Thomlinson


"Neil" wrote:

Norman,

You can have a Worksheet that's name is based on the contents of a cell.

Check out the Excel VBA toolbox on my website for a snippet of code that
allows you to do that.

HTH

Neil
www.nwarwick.co.uk

"Norman" wrote:

I would like to see to abilty to dynamically label the sheets in a workbork.
For Example, the project I execute bi-weeky has one sheet per day of the
week. If I could set this up to reference a cell or formula like I do the
date that is inserted at the top of the page. that way. This could be done
maybe as a Virtual Label so that the sheet that says it is May 15 would
always stay Sheet 2 so my hyperlink would not get broken by renaming the
sheet as that is currently te only way I could get it label.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

Jim,

You are of course correct, the snippets in the VBA toolbox sections on my
site are meant to be used by experienced programmers who would normally have
plenty of error trapping etc in place.

I'll add something to the pages just to make it a little more obvious that
that's the case. Thanks for your comments

Neil
www.nwarwick.co.uk

"Jim Thomlinson" wrote:

Your code crashes if you try to name a sheet the same name as an existing
sheet or if you try to rename the sheet to a name that is too long, or if you
try to rename it to "history". That and I think the Op was suggesting the
this be an internal feature of xl, not a macro...

--
HTH...

Jim Thomlinson


"Neil" wrote:

Norman,

You can have a Worksheet that's name is based on the contents of a cell.

Check out the Excel VBA toolbox on my website for a snippet of code that
allows you to do that.

HTH

Neil
www.nwarwick.co.uk

"Norman" wrote:

I would like to see to abilty to dynamically label the sheets in a workbork.
For Example, the project I execute bi-weeky has one sheet per day of the
week. If I could set this up to reference a cell or formula like I do the
date that is inserted at the top of the page. that way. This could be done
maybe as a Virtual Label so that the sheet that says it is May 15 would
always stay Sheet 2 so my hyperlink would not get broken by renaming the
sheet as that is currently te only way I could get it label.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming