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: trumpexcel.com...
Free Excel Course - trumpexcel.com...
Paid Online Training - trumpexcel.com...
Best Excel Books: trumpexcel.com...
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: www.youtube.co...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Негізгі бет How to Hide Worksheets in Excel (that can not be unhidden easily)
Пікірлер: 47