I am using Excel 2003. I would like to be able to use a spreadsheet format
to fill in a preprinted form. In order to more easily position the fill-in
boxes accurately on the spreadsheet, it would be useful to be able to scan in
the preprinted form and have it displayed over the spreadsheet as a
semitransparent overlay sheet. That way columns and rows could be adjusted
to place the information to be printed on the form in a more precise manner.
Currently, this involves much trial and error and test printing. This could
save a lot of time and resources.

"Eric D" <Eric wrote in message
...
I am using Excel 2003. I would like to be able to use a spreadsheet
format
to fill in a preprinted form. In order to more easily position the
fill-in
boxes accurately on the spreadsheet, it would be useful to be able to scan
in
the preprinted form and have it displayed over the spreadsheet as a
semitransparent overlay sheet. That way columns and rows could be
adjusted
to place the information to be printed on the form in a more precise
manner.
Currently, this involves much trial and error and test printing. This
could
save a lot of time and resources.

There is a way to make a user form transparent. The code assumes there's a
window that it can operate on. Using Spy++, it seems as images are not
inside a window

http://www.tek-tips.com/viewthread.c...=970078&page=1

/Fredrik

this all sounds nice, and I've tried it a looooong time ago..

but: in 1990 Excel couldnot
and in 2005 Excel CANNOT PRINT WITH PRECISION.

For fill out forms you MUST use Word or something else, but DONT use
Excel.

the slightest change on graphics drivers/printer drivers/fonts/DPI
or whatever will screw up positioning. it may be 1px but can easily be
30 pixels out of whack..

Have you EVER tried to print a square graphic using Excel?
and...have you ever measured the results?

When he's finally got it exactly right on his PC and his printer,
he can start all over for the next user.






--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Fredrik Wahlgren wrote :


"Eric D" <Eric wrote in message
...
I am using Excel 2003. I would like to be able to use a spreadsheet
format
to fill in a preprinted form. In order to more easily position the
fill-in
boxes accurately on the spreadsheet, it would be useful to be able
to scan
in
the preprinted form and have it displayed over the spreadsheet as a
semitransparent overlay sheet. That way columns and rows could be
adjusted
to place the information to be printed on the form in a more precise
manner.
Currently, this involves much trial and error and test printing.
This
could
save a lot of time and resources.

There is a way to make a user form transparent. The code assumes
there's a window that it can operate on. Using Spy++, it seems as
images are not inside a window

http://www.tek-tips.com/viewthread.c...=970078&page=1

/Fredrik