Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modifying hyperlink beyond default options
Hi.
I have a hyperlink that takes the user to range called "data_input". The range address is $A$40:$I$67. How can I modify the hyperlink so that it still takes the user to this range, but then activates only cell A40? I tried changing the hyperlink to point only to cell A40, but this doesn't bring the whole range into the user's view (which is required). Is there a way to modify the hyperlink code to activate only cell A40? Thanks. Michael *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modifying hyperlink beyond default options
The hyperlink actually Selects the "data_input" range. Since $A$40 is the
first cell in that range, it will always be the active cell after the hyperlink is clicked, even though the entire range is selected. If you are talking about activating $A$40 without having the entire range selected, give cell $A$40 a name and hyperlink to that name. Regards, Alan "Michael Siegel" wrote in message ... Hi. I have a hyperlink that takes the user to range called "data_input". The range address is $A$40:$I$67. How can I modify the hyperlink so that it still takes the user to this range, but then activates only cell A40? I tried changing the hyperlink to point only to cell A40, but this doesn't bring the whole range into the user's view (which is required). Is there a way to modify the hyperlink code to activate only cell A40? Thanks. Michael *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modifying hyperlink beyond default options
Thanks for the response Alan.
Yes, this is what I'm talking about - having cell $A$40 activated without the whole range selected. However, there is an additional problem. I did give cell $A$40 a name - but if I link to that name, the rest of the range is not in view (it is below the bottom of the screen) when the user clicks the "Jump to Input" hyperlink. My goal is to 1) have only $A$40 selected but 2) have the entire range in view when the "Jump to Input" link is clicked. Any suggestions? Thanks. Michael *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modifying hyperlink beyond default options
Try this:
With ActiveWindow .ScrollColumn = 1 .ScrollRow = 40 End With Dmitry |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modifying hyperlink beyond default options
Thank you Dmitry - this is exactly what I'm looking for. However, how
do I incorporate this into the hyperlink itself? Thanks. Michael *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
default options | Setting up and Configuration of Excel | |||
Default Search Options | New Users to Excel | |||
Modifying drop-down box options and formats | Excel Discussion (Misc queries) | |||
Modifying drop-down box options and formats | Excel Worksheet Functions | |||
Modifying Default Colors in Excel 2003 | Setting up and Configuration of Excel |