View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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