Hide Worksheets with Passwords in Excel (No Code Required)

Password protect and completely hide worksheets in Excel in order to protect sensitive data, like source data, pivot table data, etc.

This tip helps a lot when you send big workbooks to coworkers and only want them to focus on specific worksheets.

This requires no coding, no vba or macros, and it allows you to keep important worksheets and data safe so that they can’t be easily changed and messed up while you keep other front-facing worksheets visible and usable.

Resources:

00:00 How it Works
00:47 Super Hide a Worksheet from View
02:04 Password Protect Hidden Worksheets
03:30 Show a Password Protected Hidden Worksheet

#msexcel #tutorial #exceltips #freetutorial #excel

[Earth-]

This is excellent. Other videos just showing ordinary features.

[calummurray]

Can you make different passwords for different sheets. I.e. so certain people have relevant access?

[ru]

This is awsome ever i seen…Very good bro👍

[leebrendalee]

ok thats cool. --is there anyway to hide it from just one person? I would hate to have to go in every single day and unhide it seems like there mus tbe a better way

[dawnp]

If I unprotect it, make changes and hit save, and close the workbook - does the sheet default back to hidden-do I need to redo this process every time?

[arifahussain]

how to do make an ALT+F11 on a macbook? (i am using google drive excel sheet) from a macbook

[nadermounir]

Brilliant video thank u for sharing your knowledge with us

[leebrendalee]

ALT F11 did nothing in online view, have to do it in excel computer copy

[axessfinancialservices]

When ThisWorkbook setting changed to Workbook gives an error Variable used an Automation type not supported in Visual Basic. Any solution?

[syedikramullah]

How to look-up data from multiple worksheets.

[paulmartinlife]

What's the purpose of Workbook_Open? Is it just to have code in order to save as *.xlsm?