Update Page During Hyperlink

  • Thread starter Thread starter Dave Matthews
  • Start date Start date
D

Dave Matthews

Is there a way to update a page while doing a hyperlink?
I have a page that depending on what the value is on
page one (with the hyperlink) page two either hides or
shows certain rows. If I switch pages choosing sheet
tabs it works perfect. When I use a hyperlink the page
does not update.
Thanks to anyone who can help.
Dave
 
Hi,

Not exactly sure this is what you're after but this
code will fire if you click on a hyperlink in Sheet1
(go to sheet2). rightclick on tab of sheet1 and goto
view code - paste.

jeff


Private Sub Worksheet_FollowHyperlink(ByVal Target As
Hyperlink)
Sheet2.Select
End Sub
 
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

Excel Macro to hyperlink an archived worksheet to an index page 0
Hyperlink to specific page in a pdf 1
Excel 2003 Hyperlink 1
Hyperlinks 3
hyperlinking to hidden work sheets 4
Outlook How to create hyperlink with specific page of the pdf attachment in Outlook 2
Getting Excel Hyperlinks to work in a PDF File 1
Problem with successive Hyperlinking in Excel 2010 5

Back
Top