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
|