View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
 
Posts: 226
Default stars **** in cells

Unless you check the "Hide" box in the cell formatting dialog, and protect
the worksheet, but again, this is not very reliable security !

--
Regards,

Juan Pablo González

"Tom Ogilvy" wrote in message
...
You can put in a custom number format like

"*****";"*****";;"******"

but if someone selects the cell, they can see what is there in the formula
bar.

--
Regards,
Tom Ogilvy

cakonopka wrote in message
...
Hi there all.

I want to change a cell so that no matter what i enter it comes up with
stars, as it is a password cell.

cheers

from CK


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