multiple users sharing a workbook

[Lorena Ricci]

I have several people that share files. I need to set each
person up to be able to view and edit only the data
partaining to them with out seeing other peoples info.
Only managers should be able to see and edit all the data.
Any ideas on how this can be done.

 

[Ed]

Lorena,

The way I would do it requires VBA, but is pretty simple
to setup and maintain.

I would have each person's data on a different sheet.
I would give each person a unique password, and the
managers a master password.

Write some to set the xlVeryHidden property to True for
all sheets when the workbook is closed.
Write some code so when the workbook is opened the user
is prompted for a password.
Based on the pasword entered, unhide either the persons
own sheet, or all the sheets for managers.