ExcelBanter - Hidden sheets

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

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

- - Hidden sheets (https://www.excelbanter.com/excel-programming/352370-hidden-sheets.html)

Hi
I know how to hide and unhide a worksheet using VBA but can you please tell
me how to remove it from the list that appears if the user selects
Format/Sheet/Unhide
I do not want them to know it exists

Thanks

TAM

Hi

The sheets Visible property must be set to xlSheetVeryHidden

And the VBA project must be protected with password too - otherwise user can
change the Visible property back to xlSheetVisible in sheet properties
available in VBA editor.

Arvi Laanemets

"TAM" wrote in message
o.uk...
Hi
I know how to hide and unhide a worksheet using VBA but can you please
tell
me how to remove it from the list that appears if the user selects
Format/Sheet/Unhide
I do not want them to know it exists

Thanks

TAM