Scanned forms
Mark Cillis
into Excel and have it useable as a fill in form. I got the image in,
but it is a picture and hides the cells. Is there a way to either make
the image show the cells through it to make them useable or to send the
scan to the back to bring the cells to the front so I can put in the
formulas I need to run? Thanks for your help.
Mark
JE McGimpsey
Mark Cillis <ski...@cableone.net> wrote:
You can insert your scan as background (Format/Sheet/Background).
XL will tile the picture as many times as necessary to fill the
displayed sheet, so you'll need to do a few things:
1) Make sure your scanned form is an appropriate size (if scanned, it
should be, unless you've done some manipulation), and
2) Hide the unused rows and columns. One easy way, assuming your form
will use from A1:J50:
Type K:IV in the Name Box (at the left of the formula bar) and press
Return. Choose Format/Columns/Hide.
Type 51:65536 in the Name box and hit Return. Choose Format/Rows/Hide.
3) To keep the user from resizing rows and columns, protect the
worksheet (Tools/Protection/Protect Sheet...). Before doing that,
though, make sure you unlock the cells that the users should have access
to (Format/Cells/Protection, uncheck the Locked checkbox).
4) to make it further foolproof (though be warned, fools are ingenious),
you may want to prevent users from selecting cells outside your form
area. Something like this macro in the worksheet code module (CTRL-click
on the worksheet tab and choose View Code) will prevent that:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Dim rOKRange As Range
With Target
Set rOKRange = Intersect(.Cells, Me.Range("A1:J50"))
If rOKRange Is Nothing Then _
Set rOKRange = Me.Cells(Application.Min(.Row, 50), _
Application.Min(.Column, 10))
End With
Application.EnableEvents = False
rOKRange.Select
Application.EnableEvents = True
End Sub
Jim Gordon MVP
I would be inclined to use Word for this purpose. You can View > Header and
Footer then Insert > Picture > From File to get your scanned form into the
background. Position it within the header & footer dialog so that it appears
in the document appropriately. In the Wrapping section of the Formatting
Palette adjust the picture so that it appears behind text.
Then close the header & footer dialog. Use View > Toolbars > Forms to add
form controls to the Word document.
Word has a special feature in the Save-As dialog box that lets you save just
the results of the form fields. When saving a file click the Options button
in the Save-As dialog box. Check the box that says to save only the form
field information. Then switch the file type from Word document to Text
Only. The result is a text file that can be used a record in a database.
-Jim
--
Jim Gordon
Mac MVP
**Everyone is encouraged to post answers to any unanswered questions
whenever you see one that you know the answer to.
On 3/12/04 3:18 PM, in article 40521AFD...@cableone.net, "Mark Cillis"
Mark Cillis
instructions below. I only want 1 page of the scanned image for a
background and I get the whole sheet which makes the whole workbook
about 8.5mb which is way too large for a 4 sheet book. Is there a way to
suppress the background to keep in on only the equivalent of 1 page?
Thanks for your help
Mark
Mark Cillis
formulas on the data, I can't do this using Word can I?
JE McGimpsey
Mark Cillis <ski...@cableone.net> wrote:
> For some reason, I can't get the unused cells to be hidden by using the
> instructions below. I only want 1 page of the scanned image for a
> background and I get the whole sheet which makes the whole workbook
> about 8.5mb which is way too large for a 4 sheet book. Is there a way to
> suppress the background to keep in on only the equivalent of 1 page?
You'll have to crop your picture - there's no way to suppress parts of
the picture.