Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink or Command Button?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink or Command Button?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink or Command Button?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink or Command Button?
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. "HH" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink or Command Button Program | Excel Programming | |||
put a hyperlink on a command button | Excel Worksheet Functions | |||
Command Button Hyperlink | Excel Discussion (Misc queries) | |||
Command Button Hyperlink | Excel Programming | |||
How do I execute command from button or hyperlink? | Excel Discussion (Misc queries) |