Joel,
That works ok too -- except when I copy the worksheet. the GOTO takes me
back to the origional sheet. Or am I doing it wrong?

I need someway to get the GOTO to stay on the copied workheet.


"Joel" wrote in message
...
One method is to create a name (Insert menu - Names). Then move around
workbook by going to the Edit menu and selecting GOTO and picking the name
in
the list.

"HH" wrote:

My workbook has may worksheets that are used as fill in forms. I use a
blank
worksheet and duplicate it when I need a new form.

A work sheet is quite long so I have placed hyperlinks in cells at the
top
of the sheet (using freeze plane so they stay in place) to navigate to
different parts of the page. Some hyperlinks take me to different
worksheet in the workbook but most of them are used to move around the
current worksheet.

I'm sure there is a better way to navigate around the worksheet or to
other
worksheets - but I not a novice and this works ok except...

When I duplicate a sheet (the template) the hyperlink take me back to
the
original sheet. I know I can update the hyperlink but it's too easy to
forget to do this.

Is there some code that will update the hyperlinks when I copy or
duplicate
the template?

Any suggestions on how I make it easier to navigate the sheets?

Hank