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

Hi Karen

1) Press the Design button on the developer tab

2) On the View tab in the Show/Hide group Uncheck gridlines

OR : Office button>Excel options..Advanced

See display options for this sheet
Uncheck gridlines

You can hide the columns that you not use if you want



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Karen Morris" wrote in message news:20087862834ksmorris@gmail.com...
> 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