Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
how do I create locked form for filling in like name, address, date, etc,
somewhat like a fax form |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
If you mean you want to use the sheet as a form but only allow entry in certain cells, then select the cells you want unlocked and choose Format, Cells, Protection, and uncheck Locked. Then choose Tools, Protection, Protect Spreadsheet add a password or not, and unchieck Select locked cells (or not). -- Thanks, Shane Devenshire "bill" wrote: how do I create locked form for filling in like name, address, date, etc, somewhat like a fax form |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
Fill in Blanks for 1099-Div Summary Form, Office 2003 | Excel Worksheet Functions | |||
scanning form and filling in blanks | Excel Discussion (Misc queries) | |||
Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
Can I create a fill-in form on excel and then calculate the result | Excel Discussion (Misc queries) |