Unable to call through Command Button

[nehachoubey]

I have written a module ds and called it in command button(Default) like this:

Sub default_click()
call ds
End Sub

It performs all tasks except for the link with database ie ODBC part. If i run the module it runs perfectly but not throught command click. Plz help!!

 

[GTO]

What kind of command button and what module is default_click in?

 

[nehachoubey]

activex control command button and it is in the worksheet MASTER_SHEET

 

[GTO]

I'm not sure why, but a couple of things seem odd. When you insert code for an activex button, by default it inserts a private sub like:

Private Sub CommandButton1_Click()
    Stop
    Call ds
End Sub

Also, Call should automatically flip to proper case. How did you insert the procedure?

 

[nehachoubey]

No its still not working. it works when i am at the same sheet but when i am running the code and i am not at sheet it doesnt work

 

[GTO]

...it works when i am at the same sheet but when i am running the code and i am not at sheet it doesnt work

Well, that would be correct. That is why when you created the button, the code is automatically placed in the same sheet's module. The button belongs to the sheet. Place the click event code in the worksheet's module that the button is actually on.