Solved: Disable Cmd Button

[av8tordude]

I have a command button in a worksheet. If I select a cell that is not in Column A, I would like to disable the command button. Can someone assist me with this objective. Thanks in advance.

[mikerickson]

If the button is from the Forms menu, this should work.Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
With Target
ActiveSheet.Shapes("Button 1").OLEFormat.Object.Enabled = (.Column * .Columns.Count = 1)
End With
End Sub

[av8tordude]

Thank you mikerickson