How To Hide Worksheet Tabs in Excel – Hidden vs Very Hidden

HOW TO HIDE WORKSHEET TABS IN EXCEL - HIDDEN VS VERY HIDDEN // Learn to hide your spreadsheet tabs in Excel so that users cannot easily unhide them. When you make your tabs Very Hidden, a user who right-clicks on a tab in your workbook will not see any tabs to unhide. This is useful if you have data tables on other tabs in your spreadsheet that allow you to create drop-down lists on one tab that you want to send to users but you want to ensure the data table tabs remain hidden. While making your tabs Very Hidden is an extra layer of protection, you still should not send any spreadsheet that contains highly confidential information, even if it is on a Very Hidden tab.
__________
RESOURCES & GEAR
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
__________
FREE DOWNLOADS:
__________
CONNECT WITH ME:
__________
KEYWORDS: #MSWord, #M365, How To Hide Worksheet Tabs in Excel, How To Hide Spreadsheet in Excel, How To Hide Workbook in Excel, How to Unhide Very Hidden Tabs in Excel, Excel Fillable Forms, Excel Tutorial, Excel Lesson, Excel Tips and Tricks, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:

[patrickcarroll]

Hello Sharon, Thanks for a very useful and simple example of the Very Hidden function.

[yehiazakaria]

Thank you so much for the valuable information. much appreciated

[srinivasannarayanaswami]

Thanks a lot, Sharon. This suggestion is very helpful.

[shortittricks]

I am learning from you many things you are such a nice teacher your method is easy, smooth and understandable.

[-am]

You're insanely good at excell. most videos from other people I just dont get it or they dont explain properly, thanks to you I've created the best methos of recipe storing, creating and costing I've ever had, just wanna say thank you very much :)🤩

[Mily-qleo]

Great suggestion and demo. I always come back to your channel when I want to make my sheets look legit. You have easy to follow instructions and very useful topics. Thank you for all that you do.

[shojpzs]

Thanks Ma'am. This is actually good!

[sojourner]

This is great! I suspected a hidden tab in the Excel file because Microsoft's spreadsheet compare tool showed it, but I could not see that tab in the Excel document. This helped me locate and remove it! (I had to make it visible first, save the code, and then I could delete it like normal back in the Excel file.)

[oporajitaorpa]

Thank you so much dear! You're amazing. This video helps me a lot.
Love from Bangladesh ❤️🇧🇩

[missinglinq]

Great video - thank you. I just prefer the very, very, very hidden method.

[franciscarloesteban]

Great demonstration. Very specific instructions. However once the sheets are "very hidden" i cannot access it using a hyperlink.

[leohopkinson]

Thanks for the tip. The only issue I have hiding tabs this way is the links to my buttons and macros don't work. Is there any way that I can hide the tabs and still use the buttons and macros from my home page?

[hectorguido]

Hi Sharon. Great video. Is there a way to put a password on individual tabs to prevent them from being opened. I know you can do whole workbook but want to add a layer more.

[harisankarl]

Good but when we hide . printing, print preview of data on the hidden page not working. macro or vba code not working

[paulSpagna]

I like to HIDE on excel the top right "Minimize" "Expand" "Close" tabs, is this possible? or in the other hand, make these tabs not working.

[md-mohammed]

Hello madam,
After I change the visible property to xlsheetvisible,
I got message, unable to set the visible property....

Please advise What to do.
Thanks

[thiruvasagam]

I hide particulars columns and save it ...but i want hidden in the particular colums ????i want answer now mam ....

[chanardcatchillar]

How to unhide very hidden sheet after?

[sentineilsison]

How about if there is no tab available anymore? All the sheets were VERY VERY HIDDEN and there is nothing to right click on.

[excellover]

Whoever watched your this video can easily unhide the sheets now 😂😂