View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
dominicb[_177_] dominicb[_177_] is offline
external usenet poster
 
Posts: 1
Default can you encrypt an excel cell


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