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

КОМЕНТАРІ •