View Single Post
  #3   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?

Thaks Tom,

I did what you suggested.

" format =Cells= Protection tab, click on hidden and locked"

then Protected the Sheet & Put condition on to Conditional formatting.
Until now OK.

But when I select the range of cells as if i was going to drag, or copy
them. I still can see the values in the cells through the dim screen
that excel puts on the cells to indicate that those cells are selected.
It is possible avoid this to prevent the user see what number is in the
cell?


Thanks for your help.

Regards

jose luis


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