View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default masking credit card info when worksheet is printed

Hi terwilli

With code you can do it or use CF

For CF see
http://www.contextures.com/xlCondFormat03.html#Print

For code see
http://www.rondebruin.nl/print.htm#Hide

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"terwilli" wrote in message ...
I have grouped a few cells together to be able to enter a credit card number
in my worksheet. I want the CC info to be visible when I am looking at the
saved worksheet, but I want the CC info to be masked with black squares or
X's when I print the worksheet. Is this possible. Thanks for any help.