Jose
Try FormatCellsCustom ;;;
Won't show through the back color.
Gord Dibben Excel MVP
On Wed, 15 Sep 2004 12:48:00 -0500, jose luis
wrote:
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/