Excel VBA: Link to Hidden Sheets & Auto-Hide for Seamless Navigation πŸ”—

Learn how to create hyperlinks to hidden worksheets in Excel using VBA, and automatically hide sheets when you leave them for a smooth user experience. Perfect for advanced Excel users!

Excel VBA: Link to Hidden Sheets & Auto-Hide for Seamless Navigation πŸ”—
Computergaga
68.8K views β€’ Jan 17, 2019
Excel VBA: Link to Hidden Sheets & Auto-Hide for Seamless Navigation πŸ”—

About this video

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

Tags and Topics

Browse our collection to discover more content in these categories.

Video Information

Views

68.8K

Likes

648

Duration

14:42

Published

Jan 17, 2019

User Reviews

4.4
(13)
Rate:

Related Trending Topics

LIVE TRENDS

Related trending topics. Click any trend to explore more videos.