If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Locked hidden cells
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? |
#2
|
|||
|
|||
Locked hidden cells
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? |
#3
|
|||
|
|||
Locked hidden cells
"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 |
Thread Tools | |
Display Modes | |
|
|