Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default how to hyperlink b/w two sheets?

Tariq,
Use a formula like =HYPERLINK("c:\book1.xls#A10","ClickMe")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Tariq" wrote in message
...
Hi,

can any one tell me how to hyperlink b/w two sheets in Excel automation?

im workin in vb.net.

Thankz!

Tariq



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default how to hyperlink b/w two sheets?

thanks Chip for ur immediate reply, but could u tell me plz how can this
formula be implemented to refer to sheet2 from sheet1?
for e.g. i hav 3 sheets in excel and i want to hyperlink sheet 1's 6th cell
to sheet 2's 7th cell, so wat would be the formula in that scenario?

thankz!

Tariq

"Chip Pearson" wrote:

Tariq,
Use a formula like =HYPERLINK("c:\book1.xls#A10","ClickMe")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Tariq" wrote in message
...
Hi,

can any one tell me how to hyperlink b/w two sheets in Excel automation?

im workin in vb.net.

Thankz!

Tariq




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
Hyperlink Alternate Sheets Dolphinv4 Excel Discussion (Misc queries) 3 December 13th 07 01:49 AM
hyperlink some 10 sheets in a workbook anil Excel Discussion (Misc queries) 2 March 15th 07 01:19 PM
Hyperlink to hiden sheets Mick Excel Worksheet Functions 3 December 22nd 06 12:14 AM
auto hyperlink between many sheets? gab2409 Excel Discussion (Misc queries) 4 June 9th 06 10:34 PM
hyperlink to other sheets in the workbook using vba pimar[_8_] Excel Programming 0 February 21st 06 10:25 PM


All times are GMT +1. The time now is 04: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"