Cool Tricks with Excel Hyperlink Buttons

0:23 Creating Buttons
1:20 Inserting Hyperlinks
2:00 Preventing Hyperlinks Breaking
4:35 Tabbed Hyperlinks

[bc]

This is fantastic, thank you! Feels like a stepping stone toward "Turn Your Excel Into An App!" and, like you said, would be great if you have other people using your sheets.

[douglasbrown]

Great video! I like how you used a defined name as the basis for the hyperlinks. I have also found that using VBA as a means to build a navigation system (userform) works well too. I reference the worksheets VBA code name and not the tab name. Of course this takes a bit longer to design, but if you lock down the VBE the end-user is not able to mess things up by deleting a hyperlink, name range or changing the worksheet tab name. Your demonstrated way in the video is really a great way to handle a multi-worksheet workbook. Thank you for another well-produced and informative video!

[alphaxg]

This channel provides the absolute best and most comprehensive excel training on the internet. Absolutely brilliant training. And I cannot believe that it's free.

[oliverbuckley]

Very good video Mynda. I’ve been using the hyperlinks for years but never knew about being able to assign them to buttons. Tabs approach’s very clever.

[iankr]

Brilliant, Mynda.
"Rinse and Repeat" 😊❤

[IvanCortinas_ES]

Thank you for the information Mynda. All is perfect, as always!!

[tomkochka]

Loved this. It made a report I designed look much more professional. Thank you!

[toreyharris]

Love your videos very user friendly, easy to follow along and incorporate into day to day work activities.

[msaff]

How I love watching your video tutorials with different interesting solutions! Thank you for your hard work! I am Russian-speaking and you are somewhat similar to Nikolai Pavlov from Russia.

[mhstrawn]

Great video. Have long used hyperlinks in Excel and lengthy Word docs to allow users to quickly navigate large documents. Modifying them into buttons just makes it look cooler so will definitel integrate that into my efforts.

[patrickschardt]

I like the idea of “tabbed” links.

Like other things that directly reference sheets, hyperlinks should update when a sheet name is changed

[raqueldivosion]

Great video! Perfect timing to see this as I am searching for the exact tutorial! Subscribed! Keep it up!

[vijayarjunwadkar]

Very cool idea Mynda! Thanks for sharing! 😊👍

[wayneedmondson]

Hi Mynda. Some great tricks and techniques here! Thanks for sharing :)) Thumbs up!!

[RufusPattersonPodcast]

This video is just in time 🔥🔥🔥 Thanks 💪🏾💪🏾

[bczaru]

Thank you. Haven't seen that for awhile. Awesome refresher for me.

[ismaelkourouma]

Incredible that I didn’t think doing this before 😁😁😁. Thanks Mandy 😉

[chipmunk]

Thanks for all the tutorials and examples.

[richardaumais]

Thank you so much. You are a great teacher!

[darrylmorgan]

Hi Mynda!Really Like This Super Cool Technique For Hyperlink Buttons...Thank You :)