passwords for worksheets

[Hope]

Does anyone know how to password protect individual
worksheets? I have a workbook with a summary worksheet
and individual worksheets for each sales rep. I would
like to password protect the rep's worksheets so that only
they have access to their figures.

Thank you,
Hope

[Frank Kabel]

Hi
you could hide these sheets and use 'Tools - Protection - Protect
workbook' together with a password. But be aware that this kind of
protection is quite weak

--
Regards
Frank Kabel
Frankfurt, Germany

"Hope" <anon...@discussions.microsoft.com> schrieb im Newsbeitrag
news:017401c4ab0a$8d1569f0$a401...@phx.gbl...

[Hope]

Hi,

Thank you for your quick response. I have already password
protected the workbook so that only I can make changes to
it (it is read only to anyone without the password). I
also wanted to password protect individual worksheets
(each with their own password). If I just hide these
sheets, any one of the reps would be able to unhide any or
all.

Thank you
Hope

>.
>

[Frank Kabel]

Hi
for this I would create a macro which could be called via a toolbar
icon and which would ask for a password and the specific sheet. Note:
this kind of protection ist still very weak

--
Regards
Frank Kabel
Frankfurt, Germany

"Hope" <anon...@discussions.microsoft.com> schrieb im Newsbeitrag

news:020501c4ab0e$358afed0$a401...@phx.gbl...