Complicated question, for me anyway! :)

Hi-

I was wondering if someone can help me.

Is it possible, in an excel worksheet, to lock each different sheet with a
password.

I do not mean for editing purposes, i mean for visibility purposes, as in;
unless one of my employees has the required password they will not be able to
see the different parts of the whole worksheet.

My reason for asking is i am creating a holiday tracker for different parts
of my business and i do not want each department to see what each others
holiday entitlements are, please let me know if any further clarity is needed.

Many thanks,

Peter

Peter

It can be done using VBA code but not foolproof since Excel's internal security
on passworded sheets is quite weak and easily circumvented by anyone who has the
ability to seach the internet for "password crackers".

The usual rule is "if you don't want someone to see it, don't include it in the
workbook".

For more on hiding sheets as you asked see this search result.

http://groups.google.com/group/micro...64fd2b8c75a818

SnipURL is down for repairs so watch for word-wrap in the above URL.


Gord Dibben MS Excel MVP


On Sun, 18 Mar 2007 07:36:05 -0700, Peter Doak
wrote:

Hi-

I was wondering if someone can help me.

Is it possible, in an excel worksheet, to lock each different sheet with a
password.

I do not mean for editing purposes, i mean for visibility purposes, as in;
unless one of my employees has the required password they will not be able to
see the different parts of the whole worksheet.

My reason for asking is i am creating a holiday tracker for different parts
of my business and i do not want each department to see what each others
holiday entitlements are, please let me know if any further clarity is needed.

Many thanks,

Peter

Peter Doak wrote...
....
Is it possible, in an excel worksheet, to lock each different
sheet with a password.

I do not mean for editing purposes, i mean for visibility
purposes, as in; unless one of my employees has the required
password they will not be able to see the different parts of
the whole worksheet.

No. Picky point first: if you hide worksheets, you need to protect the
WORKBOOK to make it moderately difficult (and it'll only be moderately
difficult) for users to unhide the worksheets.

More fundamental: hiding worksheets only makes those worksheets
invisible. Macros in OTHER workbooks can still iterate through the
worksheets in the protected workbook, listing all it's worksheet
names. And once a user knows the worksheet names (let's say one is
named NoOneShouldSeeThis), *NOTHING* prevents them from accessing that
worksheet's contents with formulas like

=NoOneShouldSeeThis!A1

or

=[ProtectedWorkbook.xls]NoOneShouldSeeThis!A1

My reason for asking is i am creating a holiday tracker for
different parts of my business and i do not want each
department to see what each others holiday entitlements are,
please let me know if any further clarity is needed.

Anyone who puts company HR information into a spreadsheet that could
be accessed by anyone outside the HR department DESERVES the law suits
and other headaches that are nearly certain to arise from so ill-
considered an act.

Excel workbooks provide *NO* robust contents protection. Use all the
internal passwords Excel provides, and even when users don't unprotect
those workbooks they can still access *ALL* of their contents via
simple range reference formulas (as shown above).

Either give each department a completely separate workbook that
contains info for that department only, or use something other than
Excel.