XL XP template, looking for non-printing objects

[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

 

[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).

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

 

[Anne Troy]

Here's what I have done, Keith. You can use the conditional formatting tip I
show here (tho you don't have to use a dropdown to use the tip):
http://www.theofficeexperts.com/excel.htm#DropdownLists

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->