Macros and Command Buttons

I've never really programmed through Excel before, but I know Access a little so I got a new project tossed my way- I don't know VBA, but I'm sure this is a simple fix: I have two command buttons in a spreadsheet, and when either is clicked there are two macros that need to run. I'm getting "Sub or Function not defined." Forgive me for the crude hack attempts, but I'm so lost.... here's what I have.

Private Sub CommandButton1_Click()
Execute "jobaid!hidereconn"
Execute "jobaid!newconn"
End Sub

Help!

I'm not really the best at this sort of thing, but what works best for me is to copy the macro into the Sub. For instance, you'd have:

Private Sub CommandButton1_Click()

Rows("1:7").Select
Selection.Delete Shift:=xlUp
Columns("A:A").Select
Selection.Delete Shift:=xlToLeft
Range("A1").Select

End Sub

Hope this helps.
Sam

Originally Posted by foxlme

I've never really programmed through Excel before, but I know Access a little so I got a new project tossed my way- I don't know VBA, but I'm sure this is a simple fix: I have two command buttons in a spreadsheet, and when either is clicked there are two macros that need to run. I'm getting "Sub or Function not defined." Forgive me for the crude hack attempts, but I'm so lost.... here's what I have.

Private Sub CommandButton1_Click()
Execute "jobaid!hidereconn"
Execute "jobaid!newconn"
End Sub

Help!