Locking/Unlocking Cells in Protected Worksheets

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.

Originally Posted by dteresinski

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.

why don't you hide the columns?

Please Login or Register  to view this content.

Hope it helps

Originally Posted by dan2010

why don't you hide the columns?

Hope it helps

I was thinking this but my problem then is it mess up some other layout grids on the page. Its a visual thing where now I got buttons, or art boxes that aren't lined up with anything on the sheet.

I'll will take a look at it though to see if I can change it up so rhett its no issue. Would be so much easier if I could post my main file, though its way to large and way to much info is have to remove, hence why the ugly looking excel file.

Though is it possible to lock and unlock cell in the document I really think that will be my best bet with the current layout. I'm modifying someone else excel file from within the company to key the same general look for our department.

Sent from Android phone