If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hyperlinks in Access 97 | Mike in L.A. | Using Forms | 1 | March 1st, 2005 08:17 AM |
Activating a hyperlink? | AG | New Users | 1 | February 2nd, 2005 01:36 PM |
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements | Mark V | Mailmerge | 8 | November 30th, 2004 01:31 PM |
optical mouse problems in Word 97 | Jeff | New Users | 2 | June 21st, 2004 11:54 PM |
How do I stop the Hyperlink activating in many cells? | Marcus | Links and Linking | 1 | February 12th, 2004 04:49 PM |