Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 4th 05, 06:57 AM
Pawan
 
Posts: n/a
Default Hyperlink-Pawan

Hi...
I have one worksheet. My requirement is :
Upon clicking cell A1, portion through cell A5 to E15 should get selected,
in the same worksheet. I want to create hyperlink in cell A1. But I dont know
how to do this? Can anybody help me.
Thanks in advance.

-Pawan

  #2   Report Post  
Old August 4th 05, 07:07 AM
JE McGimpsey
 
Posts: n/a
Default

One way:

Insert/Hyperlink, Link to: #A5:E15

In article ,
"Pawan" wrote:

Hi...
I have one worksheet. My requirement is :
Upon clicking cell A1, portion through cell A5 to E15 should get selected,
in the same worksheet. I want to create hyperlink in cell A1. But I dont know
how to do this? Can anybody help me.
Thanks in advance.

-Pawan

  #3   Report Post  
Old August 4th 05, 07:14 AM
Mangesh Yadav
 
Posts: n/a
Default

use the following code in the module of the concerned sheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
Range("A5:E15").Select
End If
End Sub

Mangesh


"Pawan" wrote in message
...
Hi...
I have one worksheet. My requirement is :
Upon clicking cell A1, portion through cell A5 to E15 should get selected,
in the same worksheet. I want to create hyperlink in cell A1. But I dont

know
how to do this? Can anybody help me.
Thanks in advance.

-Pawan





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 from one sheet to the hyperlink on another AO Excel Discussion (Misc queries) 2 July 5th 05 11:27 AM
Importing Data from an Access Database Including a Hyperlink Colum B.C.Lioness Excel Discussion (Misc queries) 0 May 16th 05 05:26 PM
Importing Access File with Hyperlink B.C.Lioness Excel Discussion (Misc queries) 0 April 29th 05 10:13 PM
Removing hyperlink Frank Marousek Excel Discussion (Misc queries) 3 January 12th 05 09:53 PM
How can I extract hyperlink value pat_rick Excel Discussion (Misc queries) 1 January 8th 05 01:17 AM


All times are GMT +1. The time now is 03:50 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017