How to stop form printing
 

I have created my form in Excel 2007. We have pre-printed forms and I do not
want the form to print only the information that I enter.
--
Thanks for your help
Dyn

How to stop form printing
 

Well, not knowing how your form in Excel was created, hard to tell you how.
If the extra pieces are objects like text boxes, control buttons, ect., you
can go into each of their properties and turn off the "Print Object" option
for them.

If you want to use the form to gather data and don't want any text, colors,
etc that are on the form to print, and assuming you've got it set up so that
the data fields print on the right place on your pre-printed forms, you could
do this:
Copy the forms sheet as a new sheet in the workbook. Clear it of everything
except row/column sizing (so that data still prints in proper locations).
Then where the data needs to be put a link back to the original sheet, so as
an example, there's something in A5 on the forms sheet that needs to be
printed, put a link (using proper sheet name) in A5 on this empty sheet with
='Form Sheet'!$A$5
same for other data cells. Print the blank sheet instead of the forms sheet?



"Dynamite" wrote:

I have created my form in Excel 2007. We have pre-printed forms and I do not
want the form to print only the information that I enter.
--
Thanks for your help
Dyn

How to stop form printing
 

Thank you for your help. I did not do a good job of explaining myself or
what I had done.

We actually have Excel 2000 (Office 2000). I have created the form and then
saved it as a template which saved it as a workbook. I have been trying to
get it to save as an "on-screen worksheet only" but am not sure how to get it
to accomplish this. I want the form to show on the screen so that we can
type in numerous fields of information. We are not using macros as this
information changes on a daily basis and we will be typing the info into the
form. The problem is that when we type in the info it not only distorts the
form on the screen but it will also print the form. We are using pre-printed
forms so I do not want it to print over the top.
--
Thanks for your help
Dyn


"JLatham" wrote:

Well, not knowing how your form in Excel was created, hard to tell you how.
If the extra pieces are objects like text boxes, control buttons, ect., you
can go into each of their properties and turn off the "Print Object" option
for them.

If you want to use the form to gather data and don't want any text, colors,
etc that are on the form to print, and assuming you've got it set up so that
the data fields print on the right place on your pre-printed forms, you could
do this:
Copy the forms sheet as a new sheet in the workbook. Clear it of everything
except row/column sizing (so that data still prints in proper locations).
Then where the data needs to be put a link back to the original sheet, so as
an example, there's something in A5 on the forms sheet that needs to be
printed, put a link (using proper sheet name) in A5 on this empty sheet with
='Form Sheet'!$A$5
same for other data cells. Print the blank sheet instead of the forms sheet?



"Dynamite" wrote:

I have created my form in Excel 2007. We have pre-printed forms and I do not
want the form to print only the information that I enter.
--
Thanks for your help
Dyn

How to stop form printing
 

I think my previous response is still applicable. The only thing I would add
to it, based on your statement that "... it not only distorts the form..." is
to go to each of the fields on the form where this is expected to happen and
use
Format | Cells | [Alignment]
then in the 'Text Control' area, check the box next to "Shrink to fit"

Then again do as I suggested befo make a copy of that sheet and delete
everything visible on it. That will just leave your cells with the proper
sizing.

In the cells that are the same address as cells on the form to be used, type
in linking formulas back to the on-screen form. Example: assuming name of
the sheet with the form laid out that you don't want to print is named Forms
Sheet, and you type some information into cell B3 on that sheet. Then on
this blank sheet, in cell B3 put the formula
='Forms Sheet'!B3
repeat for all other cells where data is entered into them on the Forms
sheet. Then print your blank sheet onto your pre-printed form.

This has the effect of having only the information you need to show up added
to your pre-printed forms in the proper location without any of the extras
you have on the Forms Sheet to make it appear on screen like the real sheet.
You and your users just have to remember to print the 'blank' sheet instead
of the forms sheet. You could record a macro while selecting and printing
that blank sheet that would help overcome that memory-lapse, especially if
you 'attach' the code to a button on the pretty form-like sheet where you
actually do your data entry. Just click the button and the proper sheet gets
selected and printed.

If you find that the 'Shrink to fit' option is shrinking the information too
much for your shipping labels, then the only option I can think of at that
point is to get pre-printed forms with bigger areas on them the next time?
Or don't let there be a next time: let the stock run out and then start
printing from your prepared form in Excel?

"Dynamite" wrote:

Thank you for your help. I did not do a good job of explaining myself or
what I had done.

We actually have Excel 2000 (Office 2000). I have created the form and then
saved it as a template which saved it as a workbook. I have been trying to
get it to save as an "on-screen worksheet only" but am not sure how to get it
to accomplish this. I want the form to show on the screen so that we can
type in numerous fields of information. We are not using macros as this
information changes on a daily basis and we will be typing the info into the
form. The problem is that when we type in the info it not only distorts the
form on the screen but it will also print the form. We are using pre-printed
forms so I do not want it to print over the top.
--
Thanks for your help
Dyn


"JLatham" wrote:

Well, not knowing how your form in Excel was created, hard to tell you how.
If the extra pieces are objects like text boxes, control buttons, ect., you
can go into each of their properties and turn off the "Print Object" option
for them.

If you want to use the form to gather data and don't want any text, colors,
etc that are on the form to print, and assuming you've got it set up so that
the data fields print on the right place on your pre-printed forms, you could
do this:
Copy the forms sheet as a new sheet in the workbook. Clear it of everything
except row/column sizing (so that data still prints in proper locations).
Then where the data needs to be put a link back to the original sheet, so as
an example, there's something in A5 on the forms sheet that needs to be
printed, put a link (using proper sheet name) in A5 on this empty sheet with
='Form Sheet'!$A$5
same for other data cells. Print the blank sheet instead of the forms sheet?



"Dynamite" wrote:

I have created my form in Excel 2007. We have pre-printed forms and I do not
want the form to print only the information that I enter.
--
Thanks for your help
Dyn