Security Question

[Oorang]

Is there a way, without using macros to prevent someone who IS using macros from revealing a very hidden sheet?

 

[sykes]

You can password protect the actual project by bringing up the project explorer, right-clicking the project in question, and goint to "VBA project properties" then selecting "protection"
This should stop the not-too-determined user from writing any more code (macros) into the workbook, and making veryhidden sheets visible.

I'm not too sure about project password protection, but bear in mind that certainly password-protected worksheets can easily be "cracked" with liberally-available code-breakers, so as always, it comes down to how cunning and determined your users are.