Using Hyperlinks

  • Thread starter Thread starter Shelli
  • Start date Start date
S

Shelli

Hi

I have a spreadsheet with 2 worksheets in it. I would like to add
hyperlink on the 1st sheet that, when selected will open the secon
worksheet and only highlight certain cells with a large list of info.
The range of these cells could vary, so I can't use a set range o
cells. Is this possible....?

Thank
 
Hi
depens on the range definition. you may use the
worksheet_followhyperlink event. But without VBA not possible
 
You must log in or register to reply here.

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

trying to create a link to a link in Excel (2007) 3
Hyperlinks 1
Excel Macro to hyperlink an archived worksheet to an index page 0
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
VBA to Open Hyperlink(Concatenate) 7
Excel VBA 1
Lock Cells with Hyperlink 3
Hyperlink target after sort? 3

Back
Top