Applying my macro to a range of cells... Solved/Closed

Question

I found this macro and it works perfectly....inserts an "x" on a single mouse click into cells, but I only want it active on a certain range of cells.  How do I change the macro to make it functionally only on c4 thru s20?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
 If UCase(Target.Value) = "X" Then
 Target.Value = ""
 Else
 Target.Value = "X"
 End If
 End Sub

ac3mark · Answer

Wow, what a scope!

*Define on what conditions the count will increment. 
Do you wish to have another X added to an already building column of "x's"?

ac3mark · Answer

Lorihohen,

You can lock down the whole sheet, by selecting all cells, then right click, and select FORMAT CELL.  Go to the protection tab, and LOCK all of the cells.

Now go to the column that you wish to have them "click" on, and unlock those cells.  Now go to the Main tab, and protect the sheet with a password.  Now, it will only heck an x on unlocked cells.  I am not certain how we can prevent "Mary" from checking on "Bob's" list, though.

lorihohen · Answer

Worked beautifully!  Thanks.  If they check a box on the wrong list, that's easily correctable.  What wasn't easily correctable was if they clicked on a heading or the some other text box, and this solved that problem.

Applying my macro to a range of cells...

3 responses

Similar discussions

Subscribe To Our Newsletter!