By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills



Step 17 - Hidden


The hidden property is similar to visible.

We all know what to hide is from the game of "hide and seek" that you probably played as a kid.

So to hide computer objects makes sense.

The verb is to Unhide.

Show/Hide are usually a toggle.

Visible is the opposite of hidden.

Some objects you can hide:
  • Sheets
  • Columns
  • Rows
  • Shapes
  • Buttons
  • Gridlines
  • Text in a cell
  • Ribbon

    Mechanisms to Hide
  • Filters
  • Right Click
  • Outline/Grouping
  • Shortcut keys

    Properties
  • .Hidden = True/False
  • .Visible = True/False


    There is also a concept of a Very Hidden sheet that you'll learn to set up.

    •    Table of Contents | Send us your feedback | © 2025 All Rights Reserved | Edit