| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
coping worksheets with hyperlinks
Hello,
I am build a budget template which will have sever worksheets within the workbook and each worksheet will be identical. The problem is that I have hyperlink to directed toward different part of the template and every time I create a new template by coping the skeleton template the hyperlinks direct back to the skeleton template does anybody have any suggests -- Andrew Jackson |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
coping worksheets with hyperlinks
Protect your hyperlink targets:
=HYPERLINK("#'Sheet3'!B9","temp") Excel will not change the text between the double quotes when the workbook or worksheet is copied. -- Gary''s Student - gsnu200740 "Jackson" wrote: Hello, I am build a budget template which will have sever worksheets within the workbook and each worksheet will be identical. The problem is that I have hyperlink to directed toward different part of the template and every time I create a new template by coping the skeleton template the hyperlinks direct back to the skeleton template does anybody have any suggests -- Andrew Jackson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying worksheets with hyperlinks to named cells | New Users to Excel | |||
| Hyperlinks within worksheets | Excel Worksheet Functions | |||
| creating hyperlinks linking to other worksheets | Excel Discussion (Misc queries) | |||
| Hyperlinks with hidden worksheets | Excel Discussion (Misc queries) | |||
| coping | New Users to Excel | |||
Linear Mode
