Allowing access by password to a worksheet in a workbook and hiding other worksh

[Sheila]

I am trying to find a way to create a workbook with many
worksheets for our employees. I would like to limit
access for each worksheet by password and only allow them
to see that worksheet, hide all the others.

 

[Norman Harker]

Hi Sheila!

Before we start on a solution, it's crucial to ask what will be the
impact if another employee gets to see someone else's sheet?

The reason why this is important is that protection in Excel is not
very secure. Programs and techniques are freely available for
circumventing the different password processes used by Excel.

A better approach might be separate workbooks for separate employees
with a master file that you can use to extract the data you need. That
involves a "physical" approach to security that is more likely to be
successful.