remove shading when printing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LFM - 20 Jul 2006 00:56 GMT

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?

Reply to this Message

Debra Dalgleish - 21 Jul 2006 04:39 GMT

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

> 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
[quoted text clipped - 10 lines]
>
> What is the best way to go about achieving my goals on this form?

Signature

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

Reply to this Message

Gail - 21 Jul 2006 18:30 GMT

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

>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
[quoted text clipped - 10 lines]
>
> What is the best way to go about achieving my goals on this form?

Reply to this Message

Chris Lavender - 22 Jul 2006 04:50 GMT

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

Best rgds
Chris Lav

> LFM
>
[quoted text clipped - 15 lines]
>>
>> What is the best way to go about achieving my goals on this form?

Reply to this Message

Rate this thread: