Printing with preprinted forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arthur F. Dunn, M.D. - 20 Jan 2005 05:41 GMT

I am currently using Excel in Office 2000. Is it possible to create a form
on screen and designate the form labels as non-printing while the data cells
would print? i.e this would be necessary to use an on-screen form with a
preprinted form. I can hide the label cells but then they disappear from
view, defeating the usefulness of the on-screen form. Would a later Excel
version offer this capability?

Reply to this Message

Paul B - 20 Jan 2005 18:07 GMT

Arthur, labels have a option to print or not, it depends on if they are from
the forms toolbar or the control toolbox as to how you set it, if they are
from the forms toolbar right click on it and format control, properties,
uncheck print object. if it is from the control toolbox there is a print
object option in the properties for the label

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

>I am currently using Excel in Office 2000. Is it possible to create a form
>on screen and designate the form labels as non-printing while the data
>cells would print? i.e this would be necessary to use an on-screen form
>with a preprinted form. I can hide the label cells but then they disappear
>from view, defeating the usefulness of the on-screen form. Would a later
>Excel version offer this capability?

Reply to this Message

Rate this thread: