Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two Questions....Order Form
Hi,
I've created a form, but I need to do two things: 1. Lock certain cells: If Cell A1=Name and Cell B1 has John Doe. How can I lock cell A1 so that it can't be modified? I'll need to do this for all other cells too. 2. Drop Down Help: I'm currently in cell C63, I need to add a drop down. The two optioms need to be "Self Install" and "Systems Intergrator", "Self install" is the defaul option. For the default options I have hidden rows 64 to 74, but when "Systems Intergrator" is selected I need to have these rows unhidden. Thanking You In Advanced Dolphy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
order form | Excel Worksheet Functions | |||
order form | Excel Discussion (Misc queries) | |||
i want a order form | Excel Discussion (Misc queries) | |||
Order form to BOL? | New Users to Excel | |||
Order Form | Excel Discussion (Misc queries) |