- Sep 4, 2014
I am trying to figure something out and I realized that it will take a little VBA to complete my request. I have a cell that is unlocked, Sheet2:A1, by default because the cell in Sheet1:A1 is blank. If someone puts text in Sheet1:A1 then I want Sheet2:A1 to lock where it can't be changed. Any help or suggestions? Any way around VBA? If not, that is fine, just trying not to complicate things too much.