The person I am helping needs to have one file wherein one worksheet can be
cloned over and over inside the same workbook. So that one worksheet is the
"template", but the file is not set up as a template.

Thanks . . . the search continues.

"Ragdyer" wrote:

Have you given any thought to using *true* XL templates.

Create your sheet (form), and then when you go to save it, expand the "Save
As Type" box and click on:
Template (*.xlt)

This places the WB in the templates folder, where you can open and use
*copies* by clicking on <File <New,
And choosing the WB name in the General tab.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"andy62" wrote in message
...
When I try that solution, it fails in the same way that the insert
hyperlink
does: if, with the workbook open, I copy the worksheet to create a new
one,
that formula still refers back to the original worksheet. The formula
does
not update to the new sheet. I'm not talking about saving the file to a
new
location, I'm trying to get the hyperlinks inside a worksheet to refer to
the
new worksheet when one is created.

Any way to get that formula to do what I need it to?

TIA.

"Gary''s Student" wrote:

Do not create hyperlinks using:
Insert Hyperlink
Instead use something like:

=HYPERLINK("#Sheet2!B9","goto")

This link will always be local. You can save theworkbook with any name
and
the link will always take you to the local Sheet2.
--
Gary''s Student - gsnu200741


"andy62" wrote:

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