Disable Cell Reference

S

SFC

Hi everyone,
Does anyone know how to protect a sheet so that it's cells cannot b
referenced from another sheet? I have a sheet that I thought was locke
down but it's values can be duplicated from another sheet using cel
references. Thanks in advance for any suggestions.
Steve..
 
H

hgrove

SFC wrote...
Does anyone know how to protect a sheet so that it's cells
cannot be referenced from another sheet? I have a sheet that I
thought was locked down but it's values can be duplicated from
another sheet using cell references. Thanks in advance for any
suggestions.
Click to expand...

Not possible. The only way to secure what's in an Excel workbook is t
give it a file-open password, so only the people who know the passwor
can open the file or access its cell values. However, every cell'
value is open & available to anyone who can open the workbook. That'
just how Excel works.

What are you trying to do? There may be alternatives
 
Top