Hidden Pages to Appear on Hyperlink

[grounded]

Hi All!

I'm hoping my question is a simple one - I was wondering if there is a way of making a hidden page appear when the user clicks a hyperlink to that page in a password protected worksheet/book?

Thanks for the help again and have a great evening!

[simpo067]

Create your hyperlink sheet then copy this code into the relevant sheet in VBA project, I've just used it and it works a treat

Please Login or Register  to view this content.

if you then paste this into each individual sheet that you require to be hyperlinked it will hide them on selecting outside of that sheet, test it on your project though, works lovely on mine but their may be a prob i haven't experienced.

Please Login or Register  to view this content.