Oh yea I forgot about that, I think that works... Great, thanks everyone

"Gord Dibben" wrote:

Did you try it? I think you misunderstood Jim's instructions.

Jim means for you to hide the sheets using FormatSheetHide.

Then ToolsProtectionProtect Workbook with a password.

Sheets cannot be unhidden unless protection is disabled.

You do not password the file from being opened or make it read-only.


Gord Dibben MS Excel MVP


On Thu, 7 Feb 2008 10:41:01 -0800, ZBelden
wrote:

I don't think that works because if you make it read only, they are still
able to unhide the sheets... I need my users to be able to see the first
sheet and none of the others.

"Jim Thomlinson" wrote:

If you hide the worksheet and password protect the book then the users will
not be able to unhide the sheet. You can choose User level security if you
have XL 2002 or better. That being said XL passwords are very easy to hack so
if you are intending to truely hide this info the best you can do is to make
it somewhat diffictult to access but by no means is it secure.
--
HTH...

Jim Thomlinson


"ZBelden" wrote:

I would like to password protect a worksheet within a workbook so you can't
see the information within the worksheet without the password. I know how to
password protect the sheet so that you are unable to edit any of the
information but you can still see it. If this is possible any help is
appretiated. Thanks