Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
New Excel user needs help with simple Macro... | New Users to Excel | |||
Can't get simple macro to run | Excel Worksheet Functions | |||
Assigning a Hyperlink to a Macro | Excel Discussion (Misc queries) |