XL XP template, looking for non-printing objects

K

Keith R

We have a hardcopy form that we can't edit (hardcopy submission of the form
is required). To make life easier for the current users, I'm putting
together an Excel template so they can fill in the information, then print
it right on this form instead of handwriting everything.

For labels, I added labels off the control toolbox and set the
properties/print object = False. This part works great.

Now I have an area of entry cells, all lumped together. I want to somehow
draw the eye to the appropriate cells for data entry, like a backcolor or
border, but I need something that has a printobject property I can set to
false, because I don't want to print anything but cell contents onto the
hardcopy form (the form is already 'dirty' and I don't want to add new
lines, shading, etc).

Is there anything else in Excel I can use to highlight cell ranges or
grouped cells, that won't print? I tried the rectangle (fill=none) but I
can't find a printobject property on that.

Any/all help appreciated!
Keith R
 
J

Jan Karel Pieterse

Hi Keith,
Now I have an area of entry cells, all lumped together. I want to somehow
draw the eye to the appropriate cells for data entry, like a backcolor or
border, but I need something that has a printobject property I can set to
false, because I don't want to print anything but cell contents onto the
hardcopy form (the form is already 'dirty' and I don't want to add new
lines, shading, etc).
Click to expand...

You might consider using one area for input and another area for printing.
Have the printing area have formulas pointing to the input area. That way
you can nicely lock up the output area so it cannot be tampered with.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Top