remove shading when printing

[LFM]

I have a form in excel that has the unlocked cells (the ones to be filled
out) shaded so they stand out to the user. (FWIW, the form is an
application for services)

When this form prints, I would like it to print simply with no highlighted
cells showing. I want the text the user entered to show, but the background
to not show.

Secondly, I have a combo box in the upper left corner of the form called
"choose office". The user selects the office, and based on the updates, the
Address and phone/fax fields are filled in on the bottom of the form. I do
not want this combo box to be viewed on the printed form.

What is the best way to go about achieving my goals on this form?

[Debra Dalgleish]

You can use conditional formatting to change the cell colour when you're
ready to print. There's an example here that hides text, and you could
adapt it to remove the fill colour:

http://www.contextures.com/xlCondFormat03.html#Print

If the combo box is from the Forms toolbar:
Right-click on the combo box, and choose Format Control
On the Properties tab, remove the check mark from Print object.
Click OK

LFM wrote:
> I have a form in excel that has the unlocked cells (the ones to be filled
> out) shaded so they stand out to the user. (FWIW, the form is an
> application for services)
>
> When this form prints, I would like it to print simply with no highlighted
> cells showing. I want the text the user entered to show, but the background
> to not show.
>
> Secondly, I have a combo box in the upper left corner of the form called
> "choose office". The user selects the office, and based on the updates, the
> Address and phone/fax fields are filled in on the bottom of the form. I do
> not want this combo box to be viewed on the printed form.
>
> What is the best way to go about achieving my goals on this form?
>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

[Gail]

LFM

To print without showing the shaded cells, on the sheet go to Print set up
and go to the Sheet tab and check the Print Black and white box


"LFM" <nothankyou@nowhere.com> wrote in message
news:Nu2dnXCnztDBWyPZnZ2dnUVZ_sudnZ2d@comcast.com...
>I have a form in excel that has the unlocked cells (the ones to be filled
>out) shaded so they stand out to the user. (FWIW, the form is an
>application for services)
>
> When this form prints, I would like it to print simply with no highlighted
> cells showing. I want the text the user entered to show, but the
> background to not show.
>
> Secondly, I have a combo box in the upper left corner of the form called
> "choose office". The user selects the office, and based on the updates,
> the Address and phone/fax fields are filled in on the bottom of the form.
> I do not want this combo box to be viewed on the printed form.
>
> What is the best way to go about achieving my goals on this form?
>

[Chris Lavender]

.... and to avoid printing the combo box, you can do Format
control...\Properties and uncheck Print object.


Best rgds
Chris Lav

"Gail" <ladylayla@gmail.com> wrote in message
news:eGpontOrGHA.4932@TK2MSFTNGP05.phx.gbl...
> LFM
>
> To print without showing the shaded cells, on the sheet go to Print set up
> and go to the Sheet tab and check the Print Black and white box
>
>
> "LFM" <nothankyou@nowhere.com> wrote in message
> news:Nu2dnXCnztDBWyPZnZ2dnUVZ_sudnZ2d@comcast.com...
>>I have a form in excel that has the unlocked cells (the ones to be filled
>>out) shaded so they stand out to the user. (FWIW, the form is an
>>application for services)
>>
>> When this form prints, I would like it to print simply with no
>> highlighted cells showing. I want the text the user entered to show, but
>> the background to not show.
>>
>> Secondly, I have a combo box in the upper left corner of the form called
>> "choose office". The user selects the office, and based on the updates,
>> the Address and phone/fax fields are filled in on the bottom of the form.
>> I do not want this combo box to be viewed on the printed form.
>>
>> What is the best way to go about achieving my goals on this form?
>>
>
>