ExcelBanter - Hiding a sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hiding a sheet (https://www.excelbanter.com/excel-programming/375986-hiding-sheet.html)

Is there a why to hide a sheet in excel? I know that I could simply
protect the relevant the cells but it would be a lot easier to simply
not have the sheet appear.

I am reasonably sure that there should be a command like that available.

I believe it's under FORMAT. Look for SHEET and you can hide from there.

" wrote:

Is there a why to hide a sheet in excel? I know that I could simply
protect the relevant the cells but it would be a lot easier to simply
not have the sheet appear.

I am reasonably sure that there should be a command like that available.

If you open the VBA editor, you can select the sheet you want to hide, and go
to the Visible property. There are three options:
-1 - xlSheetVisible
0 - xlSheetHidden
2 - xlSheetVeryHidden

The first one is obvious - the sheet is not hidden. If you want users to be
able to unhide the sheet, you can use the second one, xlSheetHidden. The
third option will only allow you to view the sheet by unhiding it through a
macro or the VBA interface.

Hopefully that helps you out!

" wrote:

Is there a why to hide a sheet in excel? I know that I could simply
protect the relevant the cells but it would be a lot easier to simply
not have the sheet appear.

I am reasonably sure that there should be a command like that available.