Disable form command buttons?

[Foo_Man_Chu]

I'm using excel 2010. Can anyone tell me if it is possible to disable a form command button so it will not be clickable? Thanks in advance.

 

[MickG]

Try this:-

 ActiveSheet.Shapes("Button 8").OLEFormat.Object.Enabled = False

Mick

 

[Foo_Man_Chu]

Thanks!

 

[sijpie]

Does this work with you?

On my test sheet it has no effect whatsoever. The button still works even if disabled. I think this is a major Excel 2010 bug. See also this forum:
http://answers.microsoft.com/en-us/...-via-vba/793de6e3-6c20-4706-876d-1421209aad98

My code:

Sub dis_enableSheet()
    With Sheets("Sheet1")
        If .Range("A2").Value = vbNullString Then
        .Range("A2").Value = "This Sheet has been disabled as it has been superseded."
   '             .Buttons("Button 2").Enabled = False
                .Shapes("Button 2").OLEFormat.Object.Enabled = False
                .Buttons("Button 2").Font.ColorIndex = 16
        Else
        .Range("A2").Value = ""
                .Buttons("Button 2").Enabled = True
                .Buttons("Button 2").Font.ColorIndex = 1
        End If
    End With
End Sub