– In House Excel Training & MS Office Blog

Excel Tutorial Excel VBA Tutorial Tutorial

Hide Excel Sheet Based on Sheet Tab Colour – VBA Macro

Chester Tugwell on February 15, 2019

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

Sub HideColouredTabs()

Dim ws As Worksheet

For Each ws In ThisWorkbook.Worksheets

If ws.Tab.Color <> False Then

ws.Visible = xlSheetHidden

End If

End Sub

VBA Code to Hide…

Excel Tutorial Tutorial

New Dynamic Array Functions & Spilled Array Formulas

Chester Tugwell on December 10, 2018

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…

Excel Tutorial Tutorial

Create a Thermometer Chart in Excel

Chester Tugwell on July 27, 2018

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…

Categories

Tags

Archives

Hide Excel Sheet Based on Sheet Tab Colour – VBA Macro

New Dynamic Array Functions & Spilled Array Formulas

Create a Thermometer Chart in Excel

Working With Workbooks in Excel VBA

Hide Excel Sheet Based on Sheet Tab Colour – VBA Macro

New Dynamic Array Functions & Spilled Array Formulas

Create a Thermometer Chart in Excel