Dear Sir,

Greetings from Qatar !

I am using MS Excel 2007. I want to create a workbook with different
worksheets for different users to be able to view and edit the content on
his/her designated worksheet. i.e. For security purpose, I want different
worksheet has a different password to
protect so that the only authorized user can view & edit the content on
his/her
designated worksheet.
For example, sheet "marketing" has a password "1234" and sheet "sales" has a
password "1235" to view and protect. Is it possible? Please kindly advise.

Many thanks in advance. Your urgent help will be really appreciated

Best regards,
Kuncheria George

Hi Minu,

I thought Gord Dibben's reply to your posting in
microsoft.public.excel.worksheet.functions would do exactly what you needed.
Maybe you missed that post?

DB

"Minu" <(E-Mail Removed)> wrote in message
news:0953DDE9-870E-4CD7-849E-(E-Mail Removed)...
> Dear Sir,
>
> Greetings from Qatar !
>
> I am using MS Excel 2007. I want to create a workbook with different
> worksheets for different users to be able to view and edit the content on
> his/her designated worksheet. i.e. For security purpose, I want different
> worksheet has a different password to
> protect so that the only authorized user can view & edit the content on
> his/her
> designated worksheet.
> For example, sheet "marketing" has a password "1234" and sheet "sales" has
a
> password "1235" to view and protect. Is it possible? Please kindly advise.
>
> Many thanks in advance. Your urgent help will be really appreciated
>
> Best regards,
> Kuncheria George
>