Forum Discussion

Copper Contributor

Jan 13, 2022

Solved

Excel VBA: if a cell not empty, then freeze or lock (do not allow to change) another cell

Hi Everybody! I have az excel file with a macro. When I select a type in cell G8, then macro will run. Then other people have to fill the table.... But in case someone change the selection of type...

excel

Macros and VBA

mtarler
Jan 13, 2022
Just add that condition to the macro. First line of the macro would be something like
IF activesheet.range("A1")<>"" then exit sub

mtarler

Silver Contributor

Jan 13, 2022

Just add that condition to the macro. First line of the macro would be something like
IF activesheet.range("A1")<>"" then exit sub

depedro11
Copper Contributor
Jan 13, 2022
thank you mtarler! it is working!