You could try, but you're doomed for failure if anyone is really interested.

Excel's security isn't meant for this kind of thing.

Maybe it's time for a separate workbook for each manager.

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

--

Dave Peterson