Do I need any macro to set sheet veryhidden?

[zico8]

Hi,

I want to set one of my sheet to be non visible.
I have set its properities to xlsheetveryhidden, but project protection by password does not work.
It will be enough when I add any (even blank) sub inside?

 

[zico8]

Hi,

I can set it up in worksheet properities but I wont the user not be able to change it to visible again.

 

[Fluff]

Did you save the workbook as macro enabled?

 

[zico8]

yes,
but it does not work (password protection) unless I put any code inside.
I can input blank sub but my question is - is this the correct colustion?

 

[Fluff]

I've never tried protecting a vba project without any code, so was unaware of this, but it does look as though you have to, either add a blank module, or put some form of code in a sheet or ThisWorkbook module.