Data Form confusion

[Marcella]

To everyone,

What should I do if I want to use a data-form (Excel built in function)
but I don't want to show every field that I have in the database?
Example: There are column A until E. I want to display all information
inside that column A-E in my data form. However, users can only change
any info on column A-D. What should I do to make the text box on column
E become gray color so that user can't change anything in that column
only.

Thanks!!!

Rgds,
Marcella


** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Dave Hawley]

Hi Marcella

You need to Unlock the cells in the columns the users CAN change, Lock
the cells in the columns they CAN'T change, then protect the sheet. You
Lock/Unlock vis Format>Cells>Protection.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Debra Dalgleish]

If you enter a formula in the first row of data in column E, the field
will be greyed out in the Data Form.

So, if there's a number in E2, type an equal sign in front of the number.
If there's text in E2, precede it with an equal sign, and enclose the
text in quotation marks, e.g.: ="Pencils"

You don't have to change any of the other rows, just the first one.

 

[Dave Hawley]

That doesn't work. At least not in in Excel 2002.

If it does work in other versions.
Be aware that the formula method will mean the user can easily add data
(without the Form) to the columns you don't want them adding to.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Dave Hawley]

Sorry, it does. I took first row as meaning the heading.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Dave Hawley]

On testing, it doesn't work! All you need to do is scroll down and ALL
other rows are editable.

Good idea if you only have 2 or 3 rows in Column E )

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Marcella]

thanks a lot guys, I will try all your suggestions

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **