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

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.

--
Yanick


"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

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" wrote:

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.

--
Yanick


"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

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

--
Yanick


"ZBelden" wrote:

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" wrote:

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.

--
Yanick


"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

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



"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

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

"CLR" wrote:

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



"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

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

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

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

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