Juicey27
09-07-2010, 02:53 PM
Excel 2007 - VBA
Unable to get command buttons to fire properly
Currently have 4 command buttons that when I click on I receive "Run-time error '438' - Object doesn;t support this property or method." I have seperate spreadsheets within workbook per name - per button already setup. The properties Name also corresponds with name of each cmdbox
Code:
Private Sub cmdJCOX_Click()
Sheets("Main").OpenSheet "Joseph Cox"
End Sub
Private Sub cmdDOT_Click()
Sheets("Main").OpenSheet "Duffy O'Toole"
End Sub
Private Sub cmdCROWLAND_Click()
Sheets("Main").OpenSheet "Clinton Rowland"
End Sub
Private Sub cmdJROMANINI_Click()
Sheets("Main").OpenSheet "Joseph Romanini"
End Sub
Unable to get command buttons to fire properly
Currently have 4 command buttons that when I click on I receive "Run-time error '438' - Object doesn;t support this property or method." I have seperate spreadsheets within workbook per name - per button already setup. The properties Name also corresponds with name of each cmdbox
Code:
Private Sub cmdJCOX_Click()
Sheets("Main").OpenSheet "Joseph Cox"
End Sub
Private Sub cmdDOT_Click()
Sheets("Main").OpenSheet "Duffy O'Toole"
End Sub
Private Sub cmdCROWLAND_Click()
Sheets("Main").OpenSheet "Clinton Rowland"
End Sub
Private Sub cmdJROMANINI_Click()
Sheets("Main").OpenSheet "Joseph Romanini"
End Sub