How to Hide Excel Sheet so it can’t be Found easily
December 24, 2020
In this article, I will show you 3 ways to make Excel sheets very hidden. They are Manually Hiding Sheets, Tweaking Page Properties and Disabling “Show sheet tabs”, respectively.
xlSheetVeryHidden VS xlSheetHidden in Excel
December 24, 2020
In this article, I will show you how to use the “Visible” property and VBA script to play around with it. There are 3 options for “Visible” property.
Categories
.
- Array Formula (3)
- Data validation (3)
- Excel Formula & Functions (34)
- Excel Skills (37)
- Excel Tips and Tricks (38)
- Finance (5)
- Formatting (8)
- Option Pricing (3)
- Pivot table (3)
- Sharing (8)
- Shortcuts (13)
- Solver (1)
- Technical (6)
- VBA (18)
