Another macro question

  • Thread starter Thread starter Valerie
  • Start date Start date
V

Valerie

I have a large spreadsheet and would like users to be
able to click on a heading bar and go to a specific place
in the spreadsheet. I have made macros which give the
keyboard shortcuts for users, but would like them to
click say A1 and be automatically brought to C87
(example).

Thanks in advance.
 
Hi, no macro required.
Enter any text in A1, then select A1 and then press button "insert
Hyperlink";
or go to Insert > Hyperlink
A window opens which asks you (in the 2nd row)
to enter your target cell (in your case C87)
Try it!
If you klick then on A1, the cell C87 will be highlighted.
Regards, Kurt
 
Rather than using macro's buttons and toolbars, what about inserting
hyperlinks, give them descriptive names, or just the cell reference if you
wish

steve
 
Back
Top