lost assign macro?

D

dcronje

When you right click the command button you see an option for "Vie
Code" the VBA Editor will appear in the sub called "Command1_Click"
You will need to type "Call" and then the name of your macro

Close the VBE window and then press your command button
 
D

Dave Peterson

Double click on the commandbutton and you'll see this type of code:

Option Explicit
Private Sub CommandButton1_Click()

End Sub


Just change it call your old macro:

Option Explicit
Private Sub CommandButton1_Click()
Call youroldmacronamehere
End Sub

(You'll have to be in design mode (also on the control toolbox toolbar) before
you double click. And remember to toggle design mode off when you're done.)
 
Top