If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to unrestrict access to a cell
i have preset option to put on a cell .. and i need to put more options to
choose from .... its tell inme that is invalid .. how can i bypass that or edit the options on that cell??? |
#2
|
|||
|
|||
how to unrestrict access to a cell
DataValidation is where you find restrictions on cell entries.
Change the options and/or change the Error Alert to "Warning" and add a message which allows any entry if user clicks OK to "continue". Gord Dibben MS Excel MVP On Tue, 27 Apr 2010 16:41:01 -0700, rayado wrote: i have preset option to put on a cell .. and i need to put more options to choose from .... its tell inme that is invalid .. how can i bypass that or edit the options on that cell??? |
Thread Tools | |
Display Modes | |
|
|