Excel VBA: Link to Hidden Sheets & Auto-Hide for Seamless Navigation 🔗

In this video, we show you how to follow a hyperlink to a hidden sheet. We also see how to automatically hide the sheet again when you leave it.

Get up to speed with Excel VBA with the Excel VBA for beginners course - http://bit.ly/2JvnnRv

Setting up hyperlinks to other worksheets is fine, but if it is hidden the hyperlink will not work. This video shows you how to get around that issue.

It does involve VBA to identify which sheet the hyperlink is going to, unhide it and then select it.

Then there is a link to take you back which also hides the worksheet when leaving it.

Find more great free tutorials at;
https://www.computergaga.com

*** Online Excel Courses ***

Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2t3netw
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1