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 |
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) |