help with colors please

[-Brian-H-]

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?

[Paul Sheppard]

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?

Hi Brian H

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