Macro for hyperlink -pawan

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Turn of Allow Edit in Cells (tools=>Options=>Edit tab) and then double click
on the cell with the formula.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro-pawan 1
how to attach macros to excel permanently - pawan 4
Run two macros for two different sheets 11
Create executable file to run excel macro 2
lock cells for editing-pawan 1
macro to remove space 5
Value from userform to macro 2
Macro to Combine Data from Multiple Sheets with Cell References 4

Back
Top