help with colors please

B

-Brian-H-

I want to make a form more user friendly. How can I tint the cells tha
they can modify, but not have the color print on paper?

also I have a button on the form for saving the current record. th
button is pressed, a box appears asking which sheet to print, and if
change my mind and press cancel i get a "debug" box. is there a way t
not have that box appear, since it's not really needed
 
P

Paul Sheppard

-Brian-H- said:
I want to make a form more user friendly. How can I tint the cells that
they can modify, but not have the color print on paper?

also I have a button on the form for saving the current record. the
button is pressed, a box appears asking which sheet to print, and if I
change my mind and press cancel i get a "debug" box. is there a way to
not have that box appear, since it's not really needed?
Click to expand...

Hi Brian H

To stop the coloured cells printing in colour > File > Page Setup >
Sheet Tab > check the Print Black and White box
 
Top