Why open the Master?
When each employee opens his/her own workbook, that workbook's code can read
data from the master without opening the master. The user can then view,
add, delete, edit the data according to how you lock cells/ sheets in the
user's wbk.

You may or may not want users to update the master.

More information is needed.

" wrote:

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?