Note that the link shows a solution where the usernames and passwords
are stored in the workbook itself (on a veryhidden sheet).

This is VERY dangerous, since one doesn't even need to have the minimal
knowledge required to bypass any protection, in order to read usernames
and passwords in plain text.

All one needs is a hex editor.



In article ,
cbanks wrote:

http://www.ozgrid.com/forum/showthread.php?t=68586

"Liz" wrote:

I have an Excel workbook with 20 worksheets in it. We would like to make
the
workbook available on a network drive and restrict access, by user, to
individual worksheets. Is there a way to place password protection not
just
on the workbook itself but on the individual sheets? There would be
separate
passwords per sheet. If this is not possible, does anyone have ideas of
what
might work instead?