ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlink HELP (https://www.excelbanter.com/excel-discussion-misc-queries/109812-hyperlink-help.html)

DNA

Hyperlink HELP
 
I want to create a hyperlink on a worksheet and have it link to another
worksheet within the same workbook... HOW?




Rodrigo Ferreira

Hyperlink HELP
 
Select the Range (Cells in another worksheet within the same workbook) and
create a "name" for this range (something like that on menu:
"InsertNameDefine" - I don't know how is in english).
When you create a link, select the same file and the name that you created

Sorry for my poor english

Rodrigo Ferreira


"DNA" escreveu na mensagem
lkaboutsoftware.com...
I want to create a hyperlink on a worksheet and have it link to another
worksheet within the same workbook... HOW?






DNA

Hyperlink HELP
 
I get an error that indicates Cannot Open Specified File.


Rodrigo Ferreira

Hyperlink HELP
 
Don't select the same file on dialog. Select on the left of dialog
(hyperlink) a option like "On This Document" and select the name that you
created

Sorry for my poor english

Rodrigo Ferreira

"DNA" escreveu na mensagem
lkaboutsoftware.com...
I get an error that indicates Cannot Open Specified File.




DNA

Hyperlink HELP
 
Sorry, I don't understand...


Michael

Hyperlink HELP
 
DNA, with 2003, insert hyperlink, select the same file name, and then click
on bookmark and select the sheet you want. HTH
--
Sincerely, Michael Colvin


"DNA" wrote:

I want to create a hyperlink on a worksheet and have it link to another
worksheet within the same workbook... HOW?





DNA

Hyperlink HELP
 
Perfect, thank you!!


Michael

Hyperlink HELP
 
Your welcome, DNA. Thanks for the feedback.
--
Sincerely, Michael Colvin


"DNA" wrote:

Perfect, thank you!!




All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com