Hyperlink or Command Button?

[HH]

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

 

[Joel]

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]

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]

I think you are copying the sheet wrong. right click the tab on the bottom
of the sheet and select Move or copy. Then click box to create a copy. This
will create a new name for each sheet.