I have a database which I would like to allow users of the spreadsheet to enter data. However, I would like to control the format of entry. Is there a way to modify the existing excel Dataform for this purpose? For instance, to block out certain fields for input and still keep the autofilter parameters for all fields, or perhaps add drop down menus for some fields. I could probably do this through a new userform, but was looking for a shorter method.
thanks in advance.
Tom.
thanks in advance.
Tom.