Can the color of a page on a form be changed?

[gigglepott]

Hi, my users are saying that when they are printing forms they are using a lot of tonor because the form backgrounds print in grey. Is there a way to change that? I see I can change the background of the form. But if the form has pages with tabs on it I cant seem to find a way to change that color. Does anyone know? THANKS A BUNCH!!!

 

[Russ At Index]

Hi Gigglepot , Welcome To The Board.

Can you see a background by viewing :

Format --> Sheet--> Background ??.

If you can , try removing & printing....

Hope this helps.

Russ.

 

[gigglepott]

Hi Russ, thanks for the welcome!

Hmmm... I just tried looking there and there doesnt appear to be a background there. It only seems to possibly let me add a .jpg or something.

 

[Russ At Index]

Hi Gigglepot,

Possibly as silly question , please excuse me if have
have the info wrong.............................................
Are you sure it is a "background" you are trying to
avoid printing , or is it possibly shading ?????????

Russ.

p.s. What version of Excel / Windows are you running ??

 

[gigglepott]

ADVERTISEMENT

To be honest I am not 100% sure what it is I am trying not to print... shadow or background. Basically... whenever someone prints a form, it prints in grey (the microsoft default color of a form) and they want to either change the color to white or something so they stop using so much ink OR make it so it doesnt print the grey. I am using XP and Excel 6.

 

[Russ At Index]

Hi Gigglepot ,

Probably another dumb question .....
Dont suppose you are running a macro
that is forcing the print issue are you ???

Russ.

 

[gigglepott]

ADVERTISEMENT

Hi Russ, I checked and none of the macros that are set up do anything with printing. Can a macro be set up to get rid of the color when printing?

 

[Norie]

gigglepott

By form, do you actually mean a userform?

How exactly is the printing being done?

 

[gigglepott]

Hi, yup I mean a user form. All they are doing is clicking the print icon and printing what they are looking at on the screen.

 

[Norie]

Well why not put a print button on the userform?

You could transfer the data from the userform to the spreadsheet and print that instead of the actual userform.