Updating Hyperlinks when sheet name changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am using a worksheet with hyperlinks pointing to cells in the worksheet as a template. How do I get the hyperlinks to update so they refer to a new sheet name? Right now I am manually removing and recreating all the hyperlinks.

TIA


Todd
 
Howdy.

Please try posting this to an Excel newgroup.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


-----Original Message-----
Hi, I am using a worksheet with hyperlinks pointing to
cells in the worksheet as a template. How do I get the
hyperlinks to update so they refer to a new sheet name?
Right now I am manually removing and recreating all the
hyperlinks.
 
Or if trying to use Excel in FP see
http://support.microsoft.com/default.aspx?scid=268948

--




| Howdy.
|
| Please try posting this to an Excel newgroup.
|
| Jim Buyens
| Microsoft FrontPage MVP
| http://www.interlacken.com
| Author of:
| *----------------------------------------------------
| |\---------------------------------------------------
| || Microsoft Office FrontPage 2003 Inside Out
| ||---------------------------------------------------
| || Web Database Development Step by Step .NET Edition
| || Microsoft FrontPage Version 2002 Inside Out
| || Faster Smarter Beginning Programming
| || (All from Microsoft Press)
| |/---------------------------------------------------
| *----------------------------------------------------
|
|
|
| >-----Original Message-----
| >Hi, I am using a worksheet with hyperlinks pointing to
| cells in the worksheet as a template. How do I get the
| hyperlinks to update so they refer to a new sheet name?
| Right now I am manually removing and recreating all the
| hyperlinks.
| >
| >TIA
| >
| >
| >Todd
| >.
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top