[Peter A]

In article ,
says...
Subject: Convert Excel Form into Word Form
From: ?B?RGF4IEFycm93YXk=?=
Newsgroups: microsoft.public.word.docmanagement

Umm. I'm not sure how to do that. I'd like there to be fields that users
can fill out and I'd like to be able to lock the form so users couldn't type
over or change any of the text throughout the form. In other words I'd like
all the functionality that's available if it were created as a Word Form in
the first place. Is there really a way in excel to do all that? Can you
show me where?



There are two parts to this. You'll have some cells where the user can
enter info and other cells that the user should not be able to change.

For the cells where the user can enter info, use the Protection tab of
the Cell Formatting dialog (Ctrl+1, that's a one not an el) to turn off
the locked option. Then, use the Protection command on the Tools menu to
enable either worksheet or workbook protection depending on your needs.

This is a typical dumb Microsoft way of doing things - cells are locked
by default but being locked does not make any difference until
protection is turned on! You can assign a protection password, probably
a good idea.

I like to format locked and unlocked cells differently (background
shading) so it's clear to the user where he can enter info.

These instructions are for Excel 2003 but I am sure that 2007 has the
same features.


--
Peter Aitken
Author, MS Word for Medical and Technical Writers
www.tech-word.com