ExcelBanter - View Single Post - create a fill-in form using a scanned-in semi-transparent overlay

Fredrik Wahlgren

"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