73 - Making an Excel sheet Very Hidden

Published: 14 June 2024
on channel: WesleySon
32
0

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


Watch video 73 - Making an Excel sheet Very Hidden online without registration, duration hours minute second in high quality. This video was added by user WesleySon 14 June 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 32 once and liked it 0 people.