Hiding and Unhiding Sheets using VBA code

There are several reasons why people might choose to hide sheets and worksheets in Excel. Hiding sheets and worksheets in Excel can be a useful feature for maintaining data integrity, improving organization, enhancing presentation, and safeguarding sensitive information.

----
00:00 Intro
00:38 Why hide sheets or worksheets?
03:03 .Visible Property
04:16 xlSheetHidden (Hiding a sheet)
05:30 Three ways to unhide a sheet manually
06:33 xlSheetVisible (Unhiding a sheet)
06:58 (xlSheetVisible/xlSheetHidden) vs (True/False) vs (-1/0)
10:02 You cannot hide all sheets in Microsoft Excel
11:09 xlSheetVeryHidden (Hiding a sheet)
13:27 Hiding sheets in a loop
16:38 Unhiding sheets in a loop
17:03 Outro
----

Software used for recording and editing this video
Camtasia: https://techsmith.z6rjha.net/SidRecom...

Disclaimer: The above is an affiliate link. At no additional cost to you, we will receive a small commission if you make a purchase using the above links. This helps support the channel. Thank you in advance for your support!

Connect with me on social:

LinkedIn:   / siddharthrout  
Facebook:   / sidzrout  
Instagram:   / sidzthekidz  
Stackoverflow: https://stackoverflow.com/users/11405...
Microsoft Excel VBA Facebook Group:   / msexcelvba  

Sample File: https://www.dropbox.com/scl/fi/l7uemj...

#ExcelMacro #VBAExcel #MSExcel #Excel