hide sheets then password protect unhide

[rrmcguire]

Hello,

I know you can hide sheets from being visible in Excel, but once that is done with VB is there a way to password protect the unhide option?

 

[SkipVought]

Hi,

There is hidden and there is very hidden values of the Sheet Visible property.

The xlSheetHidden value can be changed either by code or on the sheet.

The xlSheeetVeryHidden value can only be seen via code or in the VB Editor. It cannot be seen from the sheet and therefore, cannot be changed from the sheet.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[rrmcguire]

got this done, after this is done throuh a macro can you prevent access to the VB editor

 

[SkipVought]

The VB Editor has a password.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[rrmcguire]

got it thanks for your help

 

[Gavona]

BUT, just so you know, those passwords are not unbreakable by any means.

Gavin