ASAP Utilities for Excel - Hide Selected Sheets as xlVeryHidden

Hide Selected Sheets as xlVeryHidden

ASAP Utilities › Sheets  ›  14. Hide Selected Sheets as xlVeryHidden

Hide selected worksheets using Excel's xlVeryHidden setting, which prevents them from being unhidden through Excel's standard Unhide option.

Unlike regular hidden sheets, xlVeryHidden sheets do not appear in the Unhide Sheets dialog. They can only be made visible again using:

  • A macro (VBA code)
  • The VBA Editor and changing the sheet's visible property
  • The "Unhide All Sheets at Once" tool in ASAP Utilities

This is useful for extra protection when you want to keep sheets hidden from casual users or prevent accidental modifications.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional keywords to help you find this tool:
Hide sheets with xlVeryHidden in Excel, Hide worksheets extra hidden, Make sheets very hidden, Prevent users from unhiding sheets in Excel, Set worksheets to xlVeryHidden mode, Protect hidden sheets from being unhidden, Hide sheets that cannot be unhidden, Make Excel sheets invisible without Unhide option

Tip:Alt+P for the previous tool.

Tip: Alt+N for the next tool.

Designed by Excel users for Excel users.
Practical tools many Excel users wish were built into Excel.

Save Time in Excel. The Easy Way.

ASAP Utilities helps you save time and do what Excel alone can't.

You can get started right away. No training needed.

Most users start with a few tools. Many end up using ASAP Utilities daily.

Used by teams in 28,500+ organizations.

Get Started with ASAP Utilities

Start saving time in Excel with practical tools you can use right away.

  • No sign-up required.

  • Free 90-day trial