Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open() Error
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_Open() Event | Excel Discussion (Misc queries) | |||
Workbook_Open () | Excel Discussion (Misc queries) | |||
Workbook_Open Event | Excel Programming | |||
WorkBook_Open Event | Excel Programming | |||
Workbook_Open() error | Excel Programming |