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. VBA Code to Hide All Coloured Sheet Tabs Sub HideColouredTabs() Dim ws As Worksheet… Read More »Hide Excel Sheet Based on Sheet Tab Colour – VBA Macro
What are Dynamic Array Formulas? Excel formulas that return multiple values (an array), will now display their results in adjacent cells. Microsoft has called this behaviour spilling, with the formulas being called spilled array formulas. Excel will automatically create an output range in which to spill results. The size of the output range will dynamically… Read More »New Dynamic Array Functions & Spilled Array Formulas
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 »Create a Thermometer Chart in Excel