THE MACRO PACK

The very-hidden macro, plus 27 more

Hide and unhide sheets in one click — plus 27 more macros you import once and use in every workbook. Free, instant, yours to keep.

What’s in the pack

VeryHideSheet and UnhideAllSheets — this video's trick, as a macro
26 more across five modules: cleaning, formatting, files, productivity
Every macro commented line by line, so you can adapt them
Three macro-enabled workbooks from my other VBA videos
A practice workbook that's broken on purpose, plus a six-page guide

Send it to my inbox

Free, instant, and yours to keep.

No spam, ever. Unsubscribe with one click.
One practical Excel tip a week.

How to Make an Excel Sheet Very Hidden (and Lock It with a Password)

Watch the 5-minute video or follow the written steps below. The macro pack is in the free download above.

Step-by-step

Right-click > Hide is easy to undo: anyone can right-click > Unhide. The very hidden setting removes a sheet from the Unhide list entirely, and a VBA project password stops people undoing it from the code editor. You don’t need to write any code.

1. Open the VBA editor

Press Alt+F11. Make sure the Project Explorer and Properties window are showing (both are on the View menu).

2. Set the sheet to Very Hidden

In Project Explorer, click the sheet you want to hide (in the example, Sheet7 (Calculations)). In the Properties window, find Visible at the bottom and choose 2 – xlSheetVeryHidden.

3. Check it worked

Press Alt+F11 to go back to Excel. The tab is gone, and if you right-click another tab, Unhide is greyed out.

4. Lock the VBA project

Anyone who knows Alt+F11 could still change it back, so add a password. In the editor, right-click VBAProject (your workbook) > VBAProject Properties > Protection. Tick Lock project for viewing, enter a strong password twice and click OK.

5. Make Excel treat it as a macro workbook

Double-click ThisWorkbook in Project Explorer. In the drop-down at the top that says (General), choose Workbook. Excel adds an empty event procedure: leave it alone. It’s only there so the protection is saved with the file.

6. Save as .xlsm

Close the editor, go to File > Save As and choose Excel Macro-Enabled Workbook (*.xlsm). If you save as a normal .xlsx, the password and the very-hidden setting are lost.

7. Test it

Close and reopen the file (enable content if asked). Unhide is still greyed out, and pressing Alt+F11 and trying to expand the project asks for the password. To bring the sheet back, unlock the project and set Visible to -1 – xlSheetVisible.

YOUR NEXT STEP

One property changed a sheet. Imagine what forty lines can do.

xlSheetVeryHidden is one property, set in one line. That’s the thing worth noticing about VBA — most of what makes Excel behave like an application is a handful of lines doing something simple. Open any module in this pack and the comments show you exactly what each line does. That’s the whole leap, and it’s smaller than people expect.

30-day money-back guarantee, handled by Udemy. No forms, no questions.

★★★★★ Join 80,000+ students

Andreas Exadaktylos · Microsoft-certified Excel instructor · mellontraining.com