Macro for hyperlink -pawan
 

I have 2 sheets. Sheet1 and sheet 2
In sheet 2, there are absolut references of sheet 1 in various cells. ( like
$J$2). I want to create hyperlink to these cells so that when I click it, it
will go to that cell directly.
Is it possible?

Thank you in advance...

-Pawan

Macro for hyperlink -pawan
 

Turn of Allow Edit in Cells (tools=Options=Edit tab) and then double click
on the cell with the formula.

--
Regards,
Tom Ogilvy


"Pawan" wrote in message
...
I have 2 sheets. Sheet1 and sheet 2
In sheet 2, there are absolut references of sheet 1 in various cells. (
like
$J$2). I want to create hyperlink to these cells so that when I click it,
it
will go to that cell directly.
Is it possible?

Thank you in advance...

-Pawan

Macro for hyperlink -pawan
 

Tom,
Its not working....Actually I dont have formula in my cells...there are only
reference to cells on other worksheets and I want to go to that location from
this reference.

"Tom Ogilvy" wrote:

Turn of Allow Edit in Cells (tools=Options=Edit tab) and then double click
on the cell with the formula.

--
Regards,
Tom Ogilvy


"Pawan" wrote in message
...
I have 2 sheets. Sheet1 and sheet 2
In sheet 2, there are absolut references of sheet 1 in various cells. (
like
$J$2). I want to create hyperlink to these cells so that when I click it,
it
will go to that cell directly.
Is it possible?

Thank you in advance...

-Pawan