I guess I didn't explain this very well, let me try again.

If someone opens a protected workbook with a password, how do I give them
different access based on which password they enter? If they open
"schedule.xls" and it asks them for a password, if they type "joe" as a
password, they get to enter data in a1. "steve" would allow them b1...

Hopefully this clears this up.

Thanks,
Chris