How to Hide with visible and invisible tricks Worksheets in Excel | Bangla Tutorial

Описание: Hiding and Unhiding with visible and invisible tricks worksheets in Excel
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.

#Excel_Bangla #Hasan_Academy #Bangla_Tutorial


Most of the people is think about that how I will learn .But they didn't get any idea & trustworthy source. Don't hesitated Hasan Academy with you. You will learn from here, Excel, Excel Chart, Pivot Table, Vlookup, Formula function