Locking a formula in a column where the values change based on drop down menu

**uhm_81** · 08-20-2014, 09:34 AM

Hello all,

I hope you are well.

I have created a drop-down menu combobox of districts and depending on your choice of districts the list of Health Centers in a specific column changes. What I want to do is to protect the contents of the column and the cells that contain the health centers. The problem is that when I lock the cells and I choose a district, the Health Center cells cannot change because the cells are locked. Is there anyway around it?

I was told to insert the following code into the sheets code:

Please Login or Register  to view this content.

I went to the Developer Tab then I chose View Code then I clicked on the Sheet 2 (Sheet 1) and I pasted the code. I got a warning saying that VBA cannot work unless I save in macro-enabled sheet so I did (xlsm).

I have attached the sample (Please look at sheet 2. The column that I want to block is the column FOSA)

Thank you
Ulises

**jewelsharma** · 08-20-2014, 09:57 PM

You should not need any VBA code for this. (I suggest removing it).
Instead, try locking all cells that you want don't want to be accidentally changed and then Protect the worksheet. Do remember to unlock the linked cell for your combobox (which is cell B4 on Sheet2 in your attached example).

HTH!