I assume the data is on the sheet so it can be used by formulas in the
workbook. If so, there is no built in way to support what you want. You
could build a macro to encrypt the data in the cells, then build a UDF that
is used inside all your formula. Something of the form:

=sum(MyDecryptUDF(SecretDataSheet!A1:A10))

--
Regards,
Tom Ogilvy


"christopher ward" wrote in
message ...
not quite this but good thoughts thank you for your efforts

my user creates a sheet called data with about 25 cols of data - he wants
to
make sure that if you use excel to view the data it cannot be understood -
a
sort of encryption, at the moment no cells are locked and they contain
mainly
text data and very few formulas . I guess its a form of visual display
change
i want
--
C Ward


"dominicb" wrote:


Good evening Christopher Ward

Do I understand that the workbook creator wants to hide formulae, but
allow the results to be seen?

Select all the cells that contain formulae to remain unseen.
Press Ctrl + 1, go to the protection tab and check the box marked
hidden.
Set the protection with Tools Protection Protect Sheet.

This will also lock all cells marked as Locked, so you mioght want to
clear the locked checkbox against all the cells that are to have an
entry before you do the last step.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
View this thread:
http://www.excelforum.com/showthread...hreadid=512999