How To Hyperlink to a Hidden Worksheet - Excel VBA

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