CREATING A DOCUMENT THAT CAN BE FILLED IN, BUT NOT MODIFYED

[AIMEEGINA]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

How can I create a form that can be filled in, however I do not want the person filling it in to be able to modify the form other than to fill it in.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

How can I create a form that can be filled in, however I do not want the
person filling it in to be able to modify the form other than to fill it in.

Simple! Just protect all the cells which you do NOT want the user to change.
(Note: cells are protected by default.) Then unprotect
(Format-Cells-Protection and uncheck locked) those cells where you DO want
the user to enter data. Then Protect the worksheet (tools-protection),
assign a password if like. When entering data, the use of the TAB key will
automatically jump to the next unlocked cell.

 

[AIMEEGINA]

THANK YOU SO MUCH!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[AIMEEGINA]

so one more thing........... this is all great, however when i try inserting an image, the options are all grayed out, any ideas??????

 

[Bob Greenblatt]

so one more thing........... this is all great, however when i try inserting
an image, the options are all grayed out, any ideas??????

That's because the worksheet is protected. You will have to unprotect it in
order to insert the image. It can then be protected again.

 

[AIMEEGINA]

so there is no way, to keep all the fields i need protected, protected but still allow a person to insert an image?

 

[JE McGimpsey]

so there is no way, to keep all the fields i need protected, protected but
still allow a person to insert an image?

If you only protect a worksheet (Tools/Protection/Protect Sheet...) for
Contents but not Objects, you can still paste images to the file.

Pictures in XL workbooks exist as objects on the drawing layer, not in
cells.

Note that any existing pictures/objects will not be protected.