• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Code to protect Cell other than Empty

I don't know if this is what you want.
The password is SPP
 

Attachments

  • Code to protect Cell other than Empty.xlsm
    22.7 KB · Views: 3
The code is to protect and unprotect only cell C3 as soon as it is filled. The others that are protected and unprotected continue.
 
Belleke

Thanks for trying to help

I'm sending an example of what I did, I just need a password for the button.
 

Attachments

  • Code to protect Cell other than Empty2.xlsm
    20.2 KB · Views: 0
I already got it
>>> use code - tags <<<
Code:
Dim Senha As String
    Senha = "SPP"
    If InputBox("Por favor, Digite a senha para continuar.", "Digite a senha") <> Senha Then
        Exit Sub
        End If
 
Last edited by a moderator:
Back
Top