ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Link title of worksheet to whatever the worksheet tab is named (https://www.excelbanter.com/excel-discussion-misc-queries/76974-link-title-worksheet-whatever-worksheet-tab-named.html)

Par3

Link title of worksheet to whatever the worksheet tab is named
 
I want the 1st line of a spreadsheet to link to the tab name so if the tab
name is changed it will automatically update. Can this be done?

Bob Phillips

Link title of worksheet to whatever the worksheet tab is named
 
See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Par3" wrote in message
...
I want the 1st line of a spreadsheet to link to the tab name so if the tab
name is changed it will automatically update. Can this be done?





All times are GMT +1. The time now is 07:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com