[Lenny]

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

[Stefan Blom[_3_]]

Ask in an Excel newsgroup such as this one:

http://www.microsoft.com/office/comm...ang=e n&cr=US

--
Stefan Blom
Microsoft Word MVP



"Lenny" wrote in message
...
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

[Stefan Blom[_3_]]

Ask in an Excel newsgroup such as this one:

http://www.microsoft.com/office/comm...ang=e n&cr=US

--
Stefan Blom
Microsoft Word MVP



"Lenny" wrote in message
...
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