73 - Making an Excel sheet Very Hidden
Вставка
- Опубліковано 5 сер 2024
- How to make a sheet Very Hidden, meaning you can't right click a sheet, press "Unhide" and make it visible again.
You need to open up VBA (Alt + F11), but you don't have to make the file a macro-enabled workbook.
This can be used to add information in a sheet that you don't want most users to see, e.g. a changelog, developer notes or simply an author stamp.
B0aty decided to visit the video, seeing as it's episode 73.
00:00 Intro
00:32 Hidden sheets aren't invisible
01:01 Allow Edit Ranges
02:03 VBA
03:07 Extra hidden
03:25 You can still reference an extra hidden sheet
04:01 Use case - Author stamp