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...
🔥 Related Trending Topics
LIVE TRENDSThis 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
About the Channel
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.