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.

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.

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.