Disable a Control Button

[ManUBlueJay]

I am Using a Forms Control button to run a macro.
I would like to have the Button disabled till certain requirements are met.
How can I disable the button. It is called Button 6

I have tried the following code but the button still works as normal even though the sheet is protected

Sheets("Entry Form").Unprotect
    ActiveSheet.Buttons("Button 6").Enabled = False
    Sheets("Entry Form").Protect

 

[JoeMo]

You could just hide the button until certain requirements are met then run the code again to unhide it:

Sub ControlMyButton()
Dim cmdButton
Set cmdButton = ActiveSheet.Shapes("Button 1")
With cmdButton
    .Visible = Not .Visible
End With
End Sub

 

[ManUBlueJay]

How would I make it visible again.
I have a range of 5 cells named "My Range". They all must have data before the button becomes usable.

 

[JoeMo]

How would I make it visible again.
I have a range of 5 cells named "My Range". They all must have data before the button becomes usable.

"My Range" is not a valid name - should that be "MyRange"? In any case, I'd suggest using change event code that runs automatically whenever a change is made to any cell in MyRange. Does that sound like what you want?