View Single Post
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Lenny Lenny is offline
external usenet poster
 
Posts: 74
Default Excel 2003 Forms (Not User Forms)

Can someone please answer some questions about how Excel works when trying to
create a form with protected/unprotected cells...
1. When the worksheet is protected, it seems to block the ability to copy &
paste objects into unprotected cells (is there a way around this?)
2. To duplicate the 'look' of existing paper forms, I have had to
combine/merge cells to approximate the same positioning in the Excel file...
when typing in an unprotected cell below the merged cells, the type
disappears where the cells above have been merged and does not spread across
the blank cells as in a regular Excel file (why?) (is there a way around
this?)

Regards - Lenny