how disable and enable button based on cell value

[abdelfattah]

hello

I have normal command button not ACTIVEX so what I want when cells value "G2" is blank then press button it seems to work but nothing happens and if the cell is "permission" then run the macro .
I know the way how do that BY BUTTON ACTIVEX but I don't want because most all the macros uses normally button if it's possible please guide me how do that .
thanks in advance

 

[Jimmypop]

Good day

Try the following: (I created a Button Form Control, not an Active X one quickly on a blank sheet to test and I think it works they way you describe)

Insert a module with following code:

Sub Button()
    If Range("G2").Value = "permission" Then
        MsgBox "permission" 'or place here the macro you want to run
        Else: Exit Sub
    End If
End Sub

Go back to sheet.
Click Design Mode.
Right Click Button.
Assign Macro called Button to the Button.

When I test this is what it does: If G2 is empty it does nothing. If G2 contains the word permission then it gives me a MsgBox (or here you can insert the code you want to run).

 

[abdelfattah]

thanks that's great

 

[Jimmypop]

Pleasure