LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 158
Default Copy worksheet with internal hyperlinks

I have seen this question asked but not answered. I have a worksheet that
serves as a template; thus it is to be copied and filled in over and over.
It includes a couple hyperlinks for navigation. When the worksheet is
copied, the links point to the template, not to the new sheet. This imposes
major risks with my audience. How can I set up the hyperlinks so that when
the worksheet is copied, they point to the right cells in the NEW worksheet?
There has to be a way . . .

TIA
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy/Paste hyperlinks between workbooks sooner1ksn Excel Discussion (Misc queries) 0 April 5th 06 03:23 PM
How to copy the url for a list of cell with hyperlinks in another column? jaya New Users to Excel 1 October 8th 05 03:26 PM
Why does excel change my hyperlinks when I copy a worksheet? TWIN HYPE New Users to Excel 1 August 29th 05 09:45 PM
Copy & paste from Word to Excel with hyperlinks Phil RL Excel Discussion (Misc queries) 0 February 9th 05 03:25 PM
how do you copy hyperlinks from one worksheet to another Philip Excel Worksheet Functions 0 February 9th 05 12:37 PM


All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"