How to Hide Worksheets in Excel (that can not be unhidden easily)

Hiding and Unhiding worksheets in Excel is a straightforward task. You can hide a worksheet and the user would not see it when he/she opens the workbook. Ho...

TrumpExcel105.4K views8:29

🔥 Related Trending Topics

LIVE TRENDS

This video may be related to current global trending topics. Click any trend to explore more videos about what's hot right now!

THIS VIDEO IS TRENDING!

This video is currently trending in Thailand under the topic 'สภาพอากาศ'.

About this video

Hiding and Unhiding worksheets in Excel is a straightforward task. You can hide a worksheet and the user would not see it when he/she opens the workbook. However, they can easily unhide the worksheet if they want (as we will see later in the video). But what if you don’t want them to be able to unhide the worksheet(s)? To do that, you need to take a couple of additional steps to make sure the worksheets are ‘very hidden’ (also covered later in this video). In this video, you will learn: -- Regular Way of Hiding a Worksheet in Excel -- How to Hide a Worksheet So That It Can Not be Unhidden -- How to Unhide a Sheet that has been ‘Very Hidden’ -- How to Hide/Unhide Worksheets Using VBA You can easily hide and unhide sheets in Excel by right-clicking on the tab and then using the hide/unhide option. But to hide in a way that it can not be easily unhidden, you need to go to the VB Editor and change the visible property of the worksheet to xlSheetVeryHidden. You can do this manually or use the VBA code covered in this tutorial. Yuu can find the VBA code here: https://trumpexcel.com/hide-worksheet/ Free Excel Course - https://trumpexcel.com/learn-excel/ Paid Online Training - https://trumpexcel.com/excel-training/ Best Excel Books: https://trumpexcel.com/best-excel-books/ ⚙️ Gear I Recommend: Camera - https://amzn.to/3bmHko7 Screen Recorder - techsmith.z6rjha.net/26D9Q USB Mic - https://amzn.to/2uzhVHd Wireless Mic: https://amzn.to/3blQ8uk Lighting - https://amzn.to/2uxOxRv Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1 Note: Some of these links here are affiliate links! #Excel #ExcelTips #ExcelTutorial

Video Information

Views
105.4K

Total views since publication

Likes
740

User likes and reactions

Duration
8:29

Video length

Published
Sep 4, 2017

Release date

Quality
hd

Video definition

Tags and Topics

This video is tagged with the following topics. Click any tag to explore more related content and discover similar videos:

Tags help categorize content and make it easier to find related videos. Browse our collection to discover more content in these categories.