masking credit card info when worksheet is printed
 

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.

masking credit card info when worksheet is printed
 

Depends on how much you know about programming but there is a workbook before
print option that you can use to change all of the numbers to say ## then
change back.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"terwilli" wrote:

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.

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.