Can anyone assist me with the below code?
I am trying to Lock/Unlock cells in a column based on data selected from data validation dropdown in another cell. However, I am getting runtime error 28 Out of stock space. My code is below and the error occurs on With Range("D5, D7, D9, D11, D13, D15, D17, D19, D21") line everytime i make a selection from the dropdown. The sheet is procted and all the cells are locked except the ones in the range above and the cell with the dropdown. What I want to do is lock and gray out the unlocked cells that dont apply to the selection made in the dropdown.
Thanks in advance with any assistance in resolving this error, or assistance with wha I am trying to do
Bookmarks