Is there any way of stopping someone getting the values of locked hidden
cells on a protected worksheet by linking to them on another worksheet?

The right person can get into anything they want regardless of protection,
the more secure you make it the more people you stop but there are always
some. As far as linking them to another sheet, if they will break protection
on one it is just as easy to do on two so I wouldn't bother, you could make
the formulas dynamically and only put them in with a password but that still
isn't much
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"tishoo" wrote:

Is there any way of stopping someone getting the values of locked hidden
cells on a protected worksheet by linking to them on another worksheet?

"John Bundy" (remove) wrote

The right person can get into anything they want regardless of protection,
the more secure you make it the more people you stop but there are always
some. As far as linking them to another sheet, if they will break
protection
on one it is just as easy to do on two so I wouldn't bother

Thanks. It seems ridiculous that you can hide data by protecting the sheet
with a password protect but then access it simply by linking from a second
sheet. Oh well, I shall just have to be insecure. Thanks for the info

T