Excel TutorialExcel VBA TutorialTutorial

Hide Excel Sheet Based on Sheet Tab Colour – VBA Macro

This video details the VBA code needed to hide worksheets that have a coloured sheet tab. It also demonstrates how to hide sheets that have a sheet tab with a specific colour assigned. The VBA code is shown below the video. https://www.youtube.com/watch?v=7XfWTecO9AI VBA Code to Hide All Coloured Sheet Tabs

VBA Code to Hide…

Read More
Excel TutorialTutorial

Create a Thermometer Chart in Excel

Thermometer charts are useful if you want to display actual values against target values: for example actual sales against sales target.  Follow the tutorial or watch our YouTube tutorial at the bottom of this page.  Please see our Excel Dashboard training course if you would like this training delivered at your place of work. Here’s an…

Read More