I need help password protecting a worksheet

[ZBelden]

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

 

[Yanick]

When you "save as" your file. In the uper right coner of the save as from
there is a "tools" drop down menu. Click on it and select general option. All
you have to do is put a password in the "password to open" field. That way,
you will not be able to even open the file without the password.

 

[ZBelden]

Yes I know how to password protect a workbook but I'm wondering if I could
password protect a worksheet within a workbook. Currently I am only able to
protect it so its 'read only' and not in the sense that if you try to go to
the worksheet it will prompt for a password before you are able to see the
information.

 

[Yanick]

Well... then I am sorry, I don't think I have a solution for you.

 

[CLR]

You would need a "helper" or "menu" sheet and some VBA to hide your sheet,
solicit the password, and unhide the sheet, then hide it again per your
conditions...........but of course if macros were not enabled, you could not
perform the unhide. If you want a non-VBA solution, I think you are out of
luck.

Vaya con Dios,
Chuck. CABGx3

 

[Jim Thomlinson]

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.

 

[ZBelden]

A macro could work.. Is that easily coded? I really don't know much VBA at
all..

 

[ZBelden]

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.

 

[Gord Dibben]

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

Jim means for you to hide the sheets using Format>Sheet>Hide.

Then Tools>Protection>Protect 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

 

[ZBelden]

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