Excel - Need to Restrict Access to Sheets for Some People

[firebirdta84]

I have an Excel document with 40 tabs, one for each employee. This one document will go out to all 40 employees. When they open the document, they will see a main menu where they will choose their name and enter a password. It will then take them to their designated sheet. It is VITAL that each employee can only see their own sheet and no one elses. I've tried hiding the sheets but you can easily unhide them in the Tools/Options menu. Hiding the sheets individually and password protecting the workbook doesn't work either, as then the VB code on the main menu throws an error. Is their a sure-fire way to do this?

Thanks,
Joe

 

[mintjulep]

No.

Excel is not designed as a secure application.

You can make it difficult for people to see information, but not impossible.

If it is really VITAL (like confidential employee information) then you need to change your approach.

 

[JPaules]

I have to agree with mintjulep. I don't want *my* data going out to 40 people with just an Excel password restricting them from accessing it. That's a lawsuit waiting to happen. You need to rethink your choice of programs.

--
JP

 

[SkipVought]

Hi,

Ditto to mj & jp!

I have a recent thread, thread68-1525860, that I will be posting as an FAQ in the near future. Missuse of Excel as a database, will be one of the Deadly Habits. Sensitive employee information should NEVER to be store in an appication like Excel. This kind of data ought to be store in a secure database!

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[buitenhek]

Agree with above comments.

You could develop a master sheet and send out individual sheets with external links to your main sheet. That way they only see their info and enter only their data. You will need to link all to the master.

Regards
Peter Buitenhek
ProfitDeveloper.com

"Never settle for a job well done...always look for cost cutting measures