Lock Excel Columns (Contains Formulas)

[vadayil]

To the Excel Gurus: How can one lock columns, so that subsequent changes to criterias of 'formula applied' will not affect the locked column, while, current data columns are active are good. An application of data validation drop down menu with option "LOCK" "UNLOCK" is preferred. Say e.g. Column A has in A1 text "LOCK" so that A5:A1000 is now NOT affected by any changes to the elements in its formula (Maybe change as values), while the same formula is active in Column B until locked (until change in B1="LOCK")so on and so forth. I am not good with VBA or building macros. I prefer formula based solution. Any help is highly appreciated.

 

[sgmpatnaik]

@vadayil


HI


welcome to Chandoo Group, Glad you are here


please check this file


https://dl.dropbox.com/u/75654703/Lock%20or%20Unlock%201.xlsm


Hope it will solve your problem


Thanks


SP

 

[Raja Kamarthi]

@ SP


Just refered to the shared excel and I must say you are highly skilled in VBA scripting


Would you mind teaching few basics of VBA to me?

 

[sgmpatnaik]

@ Raja


Hi


You are always welcome


Thanks


SP