Workbook_Deactivate, only if following hyperlink ?

staticbob

Well-known Member
Joined
Oct 7, 2003
Messages
1,079
Guys,

Is there anyway I could NOT run this code if the user is following a certain hyperlink on the sheet ? Any other way of navigating away from the sheet should fire this.

Code:
Private Sub Worksheet_Deactivate()
showhidesheets (False)
End Sub

Bob
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,118,732
Messages
5,573,893
Members
412,555
Latest member
mark84
Top