Sep 3, 2006 #1 RandDUser Technical User Feb 24, 2005 65 0 0 US In cell A1, I have the following formula: =HYPERLINK(B7, "Click Here") I want it so that when the user clicks on cell A1, the focus is moved to cell B7. The above formula does not work though. I am using Excel 2000. Any suggestions? TIA
In cell A1, I have the following formula: =HYPERLINK(B7, "Click Here") I want it so that when the user clicks on cell A1, the focus is moved to cell B7. The above formula does not work though. I am using Excel 2000. Any suggestions? TIA
Sep 3, 2006 #2 Fenrirshowl Technical User Apr 29, 2003 357 0 0 GB Looks like you missed out the workbook name and the sheet name in the path to B7. From the function help file it should follow the format: HYPERLINK("[Budget]June!B7",B7) Where Budget is the workbook and June in the worksheet. Fen Upvote 0 Downvote
Looks like you missed out the workbook name and the sheet name in the path to B7. From the function help file it should follow the format: HYPERLINK("[Budget]June!B7",B7) Where Budget is the workbook and June in the worksheet. Fen
Sep 4, 2006 1 #3 GlennUK MIS Apr 8, 2002 2,936 0 36 GB How about: Code: =HYPERLINK("#B7","friendly text") Cheers, Glenn. Did you hear about the literalist show-jumper? He broke his nose jumping against the clock. Upvote 0 Downvote
How about: Code: =HYPERLINK("#B7","friendly text") Cheers, Glenn. Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
Sep 5, 2006 Thread starter #4 RandDUser Technical User Feb 24, 2005 65 0 0 US the "#B7" worked great, thank you!! Upvote 0 Downvote
Sep 6, 2006 #5 GlennUK MIS Apr 8, 2002 2,936 0 36 GB My pleasure! Cheers, Glenn. Did you hear about the literalist show-jumper? He broke his nose jumping against the clock. Upvote 0 Downvote
My pleasure! Cheers, Glenn. Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.