Conditional Lock-Out Cell (Excel)

[icu222much]

I have a table where the user needs to fill in a group of fields via drop-down menus. If the user selects 'Yes' in certain menus, they will need to fill in additional information in the adjacent cell. To prevent confusion as to when they need to fill in the adjacent cells, I wanted to conditionally lock-out (or gray out) particular cells based on the user's input. I am wondering if this is possible?

I have took a look around and noticed that people are using macros to acomplish this. This, however, is a problem because from what I understand, you will need to run the macro in-order to lock/gray out the required cells. Is there an alternative, or will I need to do this with VBA?

 

[dhookom]

You have posted to the wrong forum. Try the VBA Visual Basic for Applications (Microsoft).

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

that is forum707

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]