Here is the situation... I have a Master spreadsheet with 20 tabs (one
for each employee) on the company network. Each customer has a
cooresponding spreadsheet that has just one tab to show their data
(which is a copy of their sheet from the master).

Since I dont want the users to go open the master, I had to password
protect the whole workbook. So When I open the employee workbook, it
prompts them for a password (as it should)

Is there a way to use vba to create a macro to unlock the Master
spreadsheet so it can read that data? The employees are not savy
enough to get into the vba code to get the password.

Any ideas?