View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default how do I create a locked form to fill in the blanks

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