ExcelBanter - How Do I Password Hide a Sheet

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

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

- - How Do I Password Hide a Sheet (https://www.excelbanter.com/excel-programming/379886-re-how-do-i-password-hide-sheet.html)

Gert-Jan[_2_]

How Do I Password Hide a Sheet

You must open the VBA editor and set the sheet to xlveryhidden. Then protect
the VBAProject(Yourmap) with a password.

"Perico" schreef in bericht
...
I don't find a feature to hide a sheet so that only a password can unhide
it.
Is there a way?

Perico[_2_]

How Do I Password Hide a Sheet

Thank you.

"Gert-Jan" wrote:

You must open the VBA editor and set the sheet to xlveryhidden. Then protect
the VBAProject(Yourmap) with a password.

"Perico" schreef in bericht
...
I don't find a feature to hide a sheet so that only a password can unhide
it.
Is there a way?

Gord Dibben

How Do I Password Hide a Sheet

Perico

You could also hide the sheet then password-protect the workbook structure
through ToolsProtection.

Gord Dibben MS Excel MVP

On Fri, 29 Dec 2006 21:32:00 -0800, Perico
wrote:

Thank you.

"Gert-Jan" wrote:

You must open the VBA editor and set the sheet to xlveryhidden. Then protect
the VBAProject(Yourmap) with a password.

"Perico" schreef in bericht
...
I don't find a feature to hide a sheet so that only a password can unhide
it.
Is there a way?

All times are GMT +1. The time now is 11:43 PM.