linkto

  1. D

    VBA Hide/Unhide Worksheets - Runtime Error

    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 =...
  2. E

    Error on "Hyperlink to a Hidden Worksheet" - Podcast #1729

    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...
  3. C

    Podcast #1729 - Hyperlink Hidden Pages

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top