Hey people, its me again :wink: . ive got another little problem. Ive assigned values to certain cells in vba. How do i protect these cells so they cannot be changed?
example of the code ive just used
how do i protect these cells using vba or should i just use the validate option in excels toolbar
example of the code ive just used
Code:
Sub Locations()
Range("J7").Value = "Germany"
Range("Q7").Value = "Italy"
End Sub
how do i protect these cells using vba or should i just use the validate option in excels toolbar