VBA to check cell value and enable/disable two other cells in same row

[dexterz]

Hello all
I'm working on an excel sheet which has 5 columns. All the cells in the columns are drop down lists with data source in a 2nd sheet. I was trying a macro that would disable editing in cells of the same row being changed. i.e., If value in c4 is changed then F4 and G4 need to be enabled/disabled, c5 will control F5 and G5 and so on...

Using the sheet protect property disables the entire F and G columns. Is there a way to modify the edit property cell wise based on the value selected in the cell in Column C?

[Mumps1]

Start by unlocking all the cells in which you will be inputting data. Next protect the sheet. Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. When you make a selection in column C, the corresponding cells in columns G and F will be locked.

Please Login or Register  to view this content.