Keeping a hyperlink in once place...!

Anthony G.

Active Member
Joined
Mar 24, 2002
Messages
465
Hello to all:

I'm trying to avoid the use of macros in a particular report, so I've opted for hyperlinks, in which case, I have listed across the top of the page. Being that I froze the Window Panes right down the middle, if a user scrolls to the right, half of the links go with it. Any suggestions?

By the Way, the links simply refer to Worksheet names within the Workbook.

Thanks,

Anthony
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

chris wood

New Member
Joined
Jun 6, 2003
Messages
27
I'm sure this is obvious to you, but can the links be put down the left side, maybe in an additional column to the left of the freeze column.

Or, could an additional row be added at the top of the worksheet so that the links that disappear when scrolling to the right could be put in new row over in the left hand pane.

Or, could an additional worksheet be added that just contained the links.

I know, not the most ingenious suggestions.
 

Anthony G.

Active Member
Joined
Mar 24, 2002
Messages
465
Thank You for the feeback....I had already experimented in similar ways to your three suggestions and was looking for a fourth...Let's keep on thinking!!!

Take Care
 

chris wood

New Member
Joined
Jun 6, 2003
Messages
27
What about just one link on the left side of the sheet that is alway visible that takes you to where first of the links that disappear reside. So if H1 has a link and the freeze is also at H1, there is a link in A1 that takes you to H1. This would take two clicks of the mouse to get where you need to go but would be much easier than scolling back or going to another worksheet for the links.
 

Anthony G.

Active Member
Joined
Mar 24, 2002
Messages
465
Like I said, never stop thinking! I like that one and will put it to work...!

Thanks,

Anthony
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,561
Messages
5,765,113
Members
425,261
Latest member
JW00

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top