xl2007 has the Unhide option built into the popup when you rightclick on any
tab. So the option is not as well buried as Format|sheet|unhide.

And there's another option that allows you to hide sheets as "very hidden". You
would need code or access to the sheet's properties (through the VBE is one way)
to unhide these very hidden sheets.

But these are not safe ways to protect intellectual property. But they can be
an effective way to hide data that the user would consider clutter--but your
workbook needs.

Bill Ridgeway wrote:

Someone on one of these NGs was asking recently how to prevent co-workers
from seeing worksheets. I've just discovered (and it wasn't mentioned at
the time) that it is possible in Excel to hide worksheets. It's not
guaranteed that someone with sufficient knowledge will not come along and
unhide the worksheet but it does put it out of sight.

Regards.

Bill Ridgeway
Computer Solutions

--

Dave Peterson