Prev: Select Words based on Specific Style
Next: Microsoft Word 2003 settings
From: Lenny on 10 Feb 2010 17:11
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
From: Stefan Blom on 11 Feb 2010 03:57
Ask in an Excel newsgroup such as this one:

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.misc&lang=en&cr=US

--
Stefan Blom
Microsoft Word MVP



"Lenny" <Lenny(a)discussions.microsoft.com> wrote in message
news:1FBA03F4-F029-495E-B317-88A798ED038E(a)microsoft.com...
> 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


 | 
Pages: 1
Prev: Select Words based on Specific Style
Next: Microsoft Word 2003 settings