Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Excel 2003 Forms (Not User Forms)
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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Excel 2003 Forms (Not User Forms)
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Forms IF Function? | Microsoft Word Help | |||
user forms and bookmarks | Microsoft Word Help | |||
VBA User Forms | Microsoft Word Help | |||
User Forms | New Users | |||
user forms in templates | Microsoft Word Help |