Ok what im trying to do is if I select Mexico on Sheet1 it should lock the Sheet2 Column B cells, unlock the Column C cells, and turn the color of the Text in Column B to white (to hide it but keep the value existing).
Now if I select Germany I want the opposite and to unlock Column B cells and lock Column C Cells and turn the text back to black for Column B.
Just trying to get a handle on this and might require more additions to the code to get some other features rolling into this. Like it would be nice if Germany is selected Column C becomes a formula (Column B * Exchange Rate), though I want to hold the value in Column C if I switch back to a Mexico pricing scheme. I don't know how to explain it without putting the worksheet up but its to loaded with company information.
Bookmarks