Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Activating a Hyperlink W/O using the mouse
I have a massive file which contains many sheets and i have one summary sheet with a column of hyperlinks which reference each sheet separately. Since i continually strive to not use my mouse, i bugs me to have to grab the mouse solely to activate a sheet. all of my work is done in rows, can i write a macro to move the courser to the left cell where the hyperlink is and activate the sheet relating to the row i'm on? or does anyone know how i can activate the Hyperlink if i move the courser there myself. Happy Friday and thanks in advance!! |
#2
|
|||
|
|||
When on the hyperlinked cell, try pressing enter. HTH, Paul "swatsley" wrote in message ... I have a massive file which contains many sheets and i have one summary sheet with a column of hyperlinks which reference each sheet separately. Since i continually strive to not use my mouse, i bugs me to have to grab the mouse solely to activate a sheet. all of my work is done in rows, can i write a macro to move the courser to the left cell where the hyperlink is and activate the sheet relating to the row i'm on? or does anyone know how i can activate the Hyperlink if i move the courser there myself. Happy Friday and thanks in advance!! |
#3
|
|||
|
|||
As for a macro, you could try something like:
__________________________ Sub ActivateCellinCurrentRow() ' Range("B" & ActiveCell.Row).Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True End Sub ____________________________ I'm assuming your link in the "left cell" is always in the same column. If so, inthe macro above "B" is the column containing the link. If there is no link in that column when the macro is executed, you will get an error. Good luck. Paul "swatsley" wrote in message ... I have a massive file which contains many sheets and i have one summary sheet with a column of hyperlinks which reference each sheet separately. Since i continually strive to not use my mouse, i bugs me to have to grab the mouse solely to activate a sheet. all of my work is done in rows, can i write a macro to move the courser to the left cell where the hyperlink is and activate the sheet relating to the row i'm on? or does anyone know how i can activate the Hyperlink if i move the courser there myself. Happy Friday and thanks in advance!! |
#4
|
|||
|
|||
I don't think Enter works - it doesn't for me anyway.
But Shortcut menu key+O does work Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#5
|
|||
|
|||
Gosh, thank you so much!!
It took me a minute to figure out which key you were referring, but i appreciate it! I've done a few seaches and wasn't albe to locate it. "Bill Manville" wrote in message ... I don't think Enter works - it doesn't for me anyway. But Shortcut menu key+O does work Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mouse continues to select after clicking on a cell in excel. | Excel Discussion (Misc queries) | |||
moving mouse lighlights cells | Excel Discussion (Misc queries) | |||
moving mouse highlights cells. why? | Excel Discussion (Misc queries) | |||
Hyperlink Length | Excel Worksheet Functions | |||
Removing hyperlink | Excel Discussion (Misc queries) |