How can I hide contents of a cell and password protect to reveal

[mlomenzo]

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

 

[Ronald R. Dodge, Jr.]

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

 

[Dave Peterson]

If that information cannot be shared with others, then don't put it into an
excel workbook.

If you have to, then don't share it with others.

Excel's worksheet protection is easily broken. It's designed to keep people
from writing over formulas (and the like). It's not meant to protect
information like this.

 

[Gord Dibben]

Ronald

For breaking internal passwords on workbook and worksheets you don't need to buy
a password cracker program.

There are many free ones.

You would probably have to buy a program to break a file-to-open password.


Gord Dibben MS Excel MVP

 

[mlomenzo]

If that information cannot be shared with others, then don't put it into an
excel workbook.

If you have to, then don't share it with others.

Excel's worksheet protection is easily broken.  It's designed to keep people
from writing over formulas (and the like).  It's not meant to protect
information like this.

In theory that is great. Just do not put it in to the sheet. If it
were that simple I would just not put it in to the sheet. However, I
need some people to access parts of the sheet while I maintain the
others. I have seen some good ideas on this discussion board I just
can not put the pieces together. Thanks for the input.
Mike

 

[mlomenzo]

Ronald

For breaking internal passwords on workbook and worksheets you don't need to buy
a password cracker program.

There are many free ones.

You would probably have to buy a program to break a file-to-open password.

Gord Dibben  MS Excel MVP



- Show quoted text -

What does this have to do with my original post???

 

[Gord Dibben]

Absolutely nothing.

I was replying to Ronald, not you.


Gord

 

[Ronald R. Dodge, Jr.]

Don't surprise me any. It's been a while since I last looked, but when I
last looked, I saw trial ones free of charge, but then would have to pay for
additional usage beyond the trial stuff, such as for more complex passwords
(getting into hashed passwords, which is still pretty weak given it's only
14 characters at mosted before password doesn't become any more complex via
hashing) or exceeding a certain number of usage.

Sincerely,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000