However, note that it's absolutely trivial to see the contents of the
hidden rows without knowing the password:

Say you want to see what's on sheet "Bob". Create a blank sheet, and
enter this in cell A1:

=Bob!A1

Copy down and across as far as necessary. You'll see everything on "Bob".

Of course, unprotecting a sheet is also absolutely trivial:

http://www.mcgimpsey.com/excel/removepwords.html




In article ,
Boo wrote:

1. Hide the rows containg data on each persons sheet
2. Then Tools Protection Protect Sheet
3. Use a different password for each sheet and pass this on to each person

This way, only the person with the password can unprotect their own sheet
and unhide the rows to view/update data.