If the data on those 6 other worksheets should be kept from the other users,
then excel isn't the application for you.

Almost any suggestion you get will depend on a macro (and macros can be disable)
and worksheet/workbook protection (and those are easily broken).

Your data will be more secure if you create 7 different workbooks (one worksheet
each) and only share each workbook with trusted co-workers.

Brandy wrote:

This is what I really want: 1 workbook with 7 worksheets. each worksheet has
it's unique "owner". i would like like the owner of that worksheet to have a
password that will allow them to open their worksheet and make modifications
as needed. each owner can ONLY open their worksheet. then 1 "general"
password that would allow an administrator to open ALL of the worksheets and
review the information as necessary.

is there a way to do all that???

--

Dave Peterson