You need a dot instead of a ,
CommandButton1.Visible
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Minitman" wrote in message ...
Greetings,
I am attempting to turn one CommandButton visible and to make another
one not visible when I open my workbook. What I am getting is a
Visual Basic error message:
Run-time error '424'
Object required
This is what I tried in "ThisWorkbook" (the * is the line
highlighted by Debug):
Private Sub Workbook_Open()
Sheets("Enter").Select
* CommandButton1,Visible = True
CommandButton2,Visible = False
Range("AP2").Select
End Sub
Anyone see what is wrong with code?
Any help would be most appreciated.
TIA
-Minitman