Update Page During Hyperlink

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
 
J

jeff

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
 
Top