wherebang

Hi all, I have a workbook that's combining time off calendars for a couple departments with hyperlinks to hidden worksheets (months) for each department. This is what I have written on the Navigation tab Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) LinkTo =...

Good Morning, I have followed step by step the above tutorial but am getting an error. The code that I typed is the following: Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) LinkTo = Target.SubAddress WhereBang = InStr(1, LinkTo, "!") If WhereBang > 0 Then...

Hey I have followed all the coding for the podcast 1729 but am getting an error: Runtime Error #9 Subscript out of range using the following code Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) LinkTo = Target.SubAddress WhereBang = InStr(1, LinkTo, "!") If...

hi,i want a solution of my problem in VBA:I have a main page (a directory for all the sheets) which is hyperlinked to numerous sheets and all have hyperlinks to take me back to the main page and the sheet hide automaticaly . My problem is when i protect workbook (structure protection) the...

using a horizontal list entitled "Training2019" with hyperlinks to 3 hidden worksheets using code: Private Sub Worksheet_FollowHyperlink (ByVal Target As Hyperlink) LinkTo = Target.SubAddress WhereBang = InStr(1, LinkTo, "!") If WhereBang > 0 Then MySheet = Left(LinkTo, WhereBang-1)...

I have some hyperlinks that go to hidden sheets on my workbook without issue. But I have a if the statement that works when the page I am hyperlinking to is not hidden. I would like it to work when it is hidden. the if then statement is =IF(EXACT(B7,"Vanco"),HYPERLINK("#Vanco!B2","Click for...

I am using the following code to unhide a worksheet and navigate to it when I click a hyperlink. For some reason, this code will fail to execute for periods of time when I open my workbook, but not every time I open it. Sometimes it will start working again in 20 minutes (without me reopening...