Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
tope12
 
Posts: n/a
Default creating hyperlinks linking to other worksheets

I know how to make hyperlinks that link to websites and documents on other
drives. My question is:

Is it possible to create a hyperlink that links to another worksheet within
the SAME* workbook? Is it also possible to have the information pop up in a
new window? For example, i want to create a hyperlink in sheet1 that links to
information in sheet3 within the SAME* workbook. Then, when i click on the
link in sheet1, the reference information in sheet3 appears in a new window.

*Im not yelling. There's no option in this post for bold, so i just used
uppercase.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default creating hyperlinks linking to other worksheets

Hi tope12. I was able to create a hyperlink to another sheet in the same
workbook by giving the workbook name as the address and then going to
bookmark. It did not open in a new window, however. You can also specify
the cell location in the target sheet. HTH
--
Sincerely, Michael Colvin


"tope12" wrote:

I know how to make hyperlinks that link to websites and documents on other
drives. My question is:

Is it possible to create a hyperlink that links to another worksheet within
the SAME* workbook? Is it also possible to have the information pop up in a
new window? For example, i want to create a hyperlink in sheet1 that links to
information in sheet3 within the SAME* workbook. Then, when i click on the
link in sheet1, the reference information in sheet3 appears in a new window.

*Im not yelling. There's no option in this post for bold, so i just used
uppercase.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Worksheets Reefaman Excel Worksheet Functions 0 February 28th 06 08:36 PM
Linking Excel Worksheets GLT New Users to Excel 6 October 27th 05 04:57 PM
Linking between multiple worksheets, workbooks and columns cmvbfore Excel Discussion (Misc queries) 0 October 4th 05 07:58 PM
Linking Several Worksheets to One Worksheet TangentMemory Excel Discussion (Misc queries) 1 May 11th 05 12:37 AM
Linking across worksheets not working as desired Steve Excel Worksheet Functions 0 April 27th 05 11:30 AM


All times are GMT +1. The time now is 02:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"