Simple Hyperlink Macro
Hi. I am using MS Excel 2003, and I am very new to the program. I don't know
how to use visual basic or programming of any kind. I need help with a
macro, and I'm hoping this is the best place to ask for help.
I have a worksheet entitled "NT." In column "A" I have a very long list of
vocabulary words (not alphabetized). For reasons I won't bother you with, I
want to establish hyperlinks for each of these words (column A) in another
worksheet entitled "LINKS" (also in column A). Thus, when I click on the
hyperlink for a word in LINKS, I will be taken to the hyperlink in NT.
I tried several times to make a macro but failed. I couldn't for the life
of me get the macro to change panes or windows (Control F6 and so on). Could
someone please help me with this macro? I would deeply appreciate your help.
Also, how can I set up a hot key so I don't have to run the macro one by one
through the entire column A in NT. In other words, could the macro be run
once and all hyperlinks be inserted in LINKS, instead of run laboriously word
by word?
|