Disable Cell Reference

[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..

 

[Nick Hodge]

AFAIK it can't be done

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[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.

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