Jay

If you protect the workbook structure after hiding the sheet you would need a
password to unprotect the workbook before unhiding the sheet.

But from your question I get the idea that you don't quite understand what
workbook protection means.

When I say "protect the workbook" I don't mean having a password to open the
workbook.

Look at ToolsProtectionProtect Workbook.

When that is enabled, FormatSheetUnhide becomes unavailable.


Gord

On Wed, 17 Jan 2007 20:20:00 -0800, Jay wrote:

Hi Gord

I'm trying to do the same thing as Laura. I like the simplicity of your
reply (I'm not a programmer...) but in this case one would still have to
provide the password to the workbook for anyone else to see it, and once open
anyone can go to a cell that contains linked information from the hidden
sheet, then FormatSheetUnhide and the hidden information is now available
to all!

Is there a way to password-protect the hidden sheet itself, so that it can't
be unlocked and viewed even if the workbook is open?

Thanks

Jay

"Gord Dibben" wrote:

FormatSheetHide

ToolsProtectionProtect Workbook.

Set a password and OK with "Structure" and "Windows" checked.

Note: Excel's internal(worksheet and workbook) protection is not very secure and
many password crackers abound on the Internet.

I suggest you stick with the two separate workbooks.

If the data is confidential, don't include it.


Gord Dibben MS Excel MVP

On Tue, 12 Dec 2006 13:54:02 -0800, laurenm
wrote:

Is there a way I can password protect a worksheet in a workbook from opening?
Not from being edited but from opening. I have a workbook which contains some
sheets with public information and one or two sheets with confidential
information. I would love to be able to password protect the confidential
worksheets from opening while the other sheets can be left alone and be
viewed as needed. Currently I am creating and distributing two separate
workbooks to our users; one with the confidential sheets and the other
without them. We are working with Excel 2002 and 2003. I look forward to any
help on this.

Thanks,
Lauren

Gord Dibben MS Excel MVP