In Excel, to hide a sheet you can select the sheet, go to menu Format, choice Sheet and finally
Hide. But the sheet will be visible in the option "Unhide".
To completely hide a sheet, you can activate VBA by pressing
ALT+F11. Navigate in the project structure to select your
sheet: VBAProject (your workbook) > Microsoft Excel Objects > SheetN (your
sheet). Then, in the Properties windows (F4 to display this window), update the property
-1- xlSheetVisible to
2 - xlSheetVeryHidden.
This way, your sheet will not be visible in the Excel user interface, but you will always be able to use data from this sheet. This is very interesting for value lists, parameters or other values that don't need to be seen or printed.
