Need Excel VBA code that will allow me to protect certain cells and not others.
$30-250 AUD
Pagato alla consegna
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
Rif. progetto: #16128060
Info sul progetto
Assegnato a:
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 freelance hanno fatto un'offerta media di $60 per questo lavoro
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 Altro
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.