Need Excel VBA code that will allow me to protect certain cells and not others.
$30-250 AUD
Paid on delivery
At the moment I have inserted VBA code into my spreadsheet to allow for clicks of the mouse to add or remove colour. When I try to insert code, in combination with my own code, to protect certain cells or use unlocked/locked functions it will not work.
I need somebody to write some code that will allow me to still protect certain cells and click to change colours on others.
I have pasted the code I used below;
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Select Case [url removed, login to view]
Case xlNone, 4: [url removed, login to view] = 3
Case Else: [url removed, login to view] = 4
End Select
End Sub
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
[url removed, login to view] = xlNone
End Sub
Project ID: #16128060
About the project
Awarded to:
I have been using VBA for a long time now to solve different business processes which native functions of Excel can't do. Feel free to message me so that we can talk more about this project.
9 freelancers are bidding on average $60 for this job
I am an Excel VBA specialist. All of my projects involve Excel and VBA so I am quite confident that I can assist you with this project. Feel free to contact me so we can discuss the details of this project.
Hi, I'm not really sure about what you want, but I think I have a solution for it. I'm waiting your reply. Thanks.
Hi, Glad to know your requirement. I am an excel vba expert and have delivered five vba projects in the past one month. Would like to do the task for you. I will do this task within 3 to 4 hours, and the deadline is 24 More
Hello there, I would like to be considered for this job as I have great working experience in VBA development. Thanks, Ramesh
i have worked with plenty of vba applications, as well as vbs applications. I can deliver in 2-3 days.