Hide Worksheets with Passwords in Excel (No Code Required)

Excel VBA/Macro Course [80% Discount]: www.teachexcel...
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:
Download the File: www.teachexcel...
Protect Excel Data (Microsoft): www.microsoft....
TeachExcel Online Courses: www.teachexcel...
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

[@calummurray9287]

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

[@alaynah.6657]

Following this... did you figure this out??

[@dawnpeppard1402]

Following this too. Any updates?

[@Earth-360]

This is excellent. Other videos just showing ordinary features.

[@ru915]

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

[@leebrendalee]

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

[@dawnpeppard1402]

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?

[@nadermounir8228]

Brilliant video thank u for sharing your knowledge with us

[@TeachExcel]

You're very welcome Nader! Thanks for the comment :)

[@philinspain65]

Perfection. Thanks.

[@k8bobatemptx]

Cool feature!

[@arifahussain9551]

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

[@kebincui]

Brilliant .

[@axessfinancialservices5124]

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

[@jukche]

super cool!

[@TeachExcel]

Thanks! Glad you liked it!!!

[@thabomosupi3312]

Superbbbb!

[@syedikramullah1114]

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?

[@TeachExcel]

Yes, exactly! You could put other code in there, but workbook_open is easy and doesn't require typing/memorizing any actual code and that's why I chose it.