Hi,

you could write a code to protect/unprotect a Master workbook in a separate
file ( Macro Recorder might help) and then send it to employees. But first
password protect the VBA module. Actually workbook password protection is
fairly easy to break using some iteration techniques, so note that Excel is
not very secure environment. VBA module protection works better.

--
______
Regards,
Greg


" 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?