First, Excel does not offer offer a significant level of protection. The
workbook/worksheet passwords can be cracked via macros in about 2-5 minutes.
Or, the managers could simple write a formula that references a hidden sheet
to find out what is stored there!

If you're going more for the conveniece, you could setup a macro that based
on:
Environ ("UserName")

would then decide which sheet to display. But again, if this information is
sensitive at all, your best bet is to place the data in seperate workbooks.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"exalan" wrote:

Hi

I am populating a sales template in one Excel workbook but I want business
unit managers to have access to view their respective worksheet only €¦ I want
to set a restriction, maybe by using password.
So, each manager will be given a password and they need to enter it when
opening the file, then they can only view what is within their own worksheet.

Is it possible in Excel to do so?

Please help....

--
exalan