I also have a such file, which requires using the combination of the
following?

Hide Rows/Columns to prevent sensitive data of being seen when workbook is
in protected mode.

VBA codes and one userform for the password required so as if the user does
type in the proper password, the code can then unhide all of the data, but
then when the file is saved, make sure all of the same stuff is set back to
the set of settings as how it was prior to the file being opened.

This is obviously no easy means as it requires some VBA skills to do as well
as using the BeforeClose and/or BeforeSave events.

One word of caution, while these password stuff will block out the honest
people, if someone really want to get into the files, they could buy a
password breaker code program, then get into it, so if you are having to
send this out to other people outside of the company, you may want to have
either some sort of legally binding agreement or simply just don't provide
such data in the workbook.

Sincerely,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
wrote in message
...
I have been doing a ton of reading and from what I can tell, there is
no "simple" solution to my problem. I have a range of cells that I
need to hide from joe user 1 but if joe user 2 has the password he can
see and edit the cells. Does this make sense? There are multiple
people that have access to this spreadsheet which is necessary. The
problem is that this sheet contains "sensitive" data that relies on
the rest of the information on the sheet. Thanks in advance for your
time.

Mike