lock/unlock cell based on another cells input

basically, I want cell g12 to be locked unless cell h7 is Grass Fire or Timber Fire (H7 is a drop down validated cell)

Make sure you set up the sheet with protection - unlock input cells, etc.

Please Login or Register  to view this content.

Copy the code
Select the worksheet in which you the want the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

You could theoretically use Data Validation on G12 also, no ?

G12: Validation: Custom: =OR(H7="Grass Fire",H7="Timber Fire")

However this won't physically clear contents of G12 as and when H7 is altered to something other than the 2 choices mentioned if that is your intention

In terms of using VBA you can use a Worksheet_Change event to physically lock/unlock the cell but this would require the entire sheet be protected - is that what you're looking to do ? It is unclear (to me at least)

I tried DonkeyOte's idea and it worked but not quite like I wanted it to.

When I tried royUK's code I come up with a compile error: Ambiguous name detected: Worksheet_SelectionChange

here is the code that I have

Please Login or Register  to view this content.

2funny4words,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

VBA Noob

The ambiguous name error is caused bevause you have two procedures with the same name, the SelectionChange event might already be in use.

Use this, it will run whenever G12 is changed

Please Login or Register  to view this content.