View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jose luis jose luis is offline
external usenet poster
 
Posts: 1
Default How to hide the content of a cell?

Friends,

I have a range of cells that use conditional formating to hide i
certain condition is met. The way of hiding it is to set the same colo
for font and pattern. It's seems to be protected from the user eye, bu
if you select with the mouse the cells is possible to "see" through th
numbers in the cells that you "Hide" through the "Conditional Formating
. Is there a way to really impede the cells from showing their contents
when you don't want the user to see certain range?

PD. It not possible to hide columns or Rows because the cells ar
insert in a Report that the user has to see. Just some cells need to b
hide from see them.


Any suggestions?


Thanks to all,

Jose Lui

--
Message posted from http://www.ExcelForum.com