2013 excel to 2016 excel now creating a bug

Hi Everyone,

I'm after a little help if possible.

I have a programme that basically controls the issuing of documentation on a site, because there can be anything from 1 to 70 tabs visible depending on their selections of requirements as they work their way through it.
Due to the large no of tabs, I had a hyperlinked index sheet which you could select the name of the sheet in column K and it would hyperlink you to cell A1 on that particular tab.

This has always worked up until the latest updates released from Microsoft.

When I use the programme in 2013 excel it works fine, so at present we have had to revert our machines back to 2013 excel to get us by.

However I do like some of the things available in 2016 excel, it also made some of our other programmes run a little quicker, so ideally id like to still use it.

Below is the code I use, maybe they have changed some of the words used within excel?

Apologies I'm pretty new to coding and I took bits of the code from something I found on the web.


Any help really appreciated!

Please Login or Register  to view this content.

Hello margal,

I don't see anything in your code that is incompatible with 2016. If you received an error message was the number or description?