Just what I needed. Thanks much
dave

Hi Peo,

I am creating a form in Excel 2007, placing ActiveX combo boxes on a sheet next to a question that prompts  their choices from the pull-down menu of the combo box.  The gathered data is being linked to a single-row at the bottom of the sheet (which I can hide from user's view) and will be transfered to a data depository master sheet--where it can be used as hard-typed (i.e., not linked data) via a macro.

I am having two problems:

1)  I cannot get an ActiveX text box to function such that it allows the user to type text input into it.  The text box is behaving as a "display only" text box.  I have been looking in Properties for this activeX control and cannot, for the life of me, figure out how to set the properties so that the text box allows input by the user;

2) my second issue is how to have the finalized form--developed on a spreadsheet--display without all the unused columns to the right of the printable page showing in the user's window.  I'd also like to hide the greyed cell lines from the user's view

Thanks,

K Morris

Thanks for the tip

Dave

Do not remember where it is in 2003 but I know it is there.
I remember doing this with Excel 98 or 2000 but never would have found it in
2007.
I think it will be easy find in 2003 and if memery server from the menu
Menu->Data->Forms

dave