Help on excel 2000 macro

  • Thread starter Thread starter excellover
  • Start date Start date
E

excellover

I was trying to creat a commanbutton and assign a macro command to that
commanbutton, I used to do it on exel 97 direct from the commandbutton
by right click and assigning it easy step , but on excel 2000 I could
not assign macro to the commanbutton.

Any help is hight apperciated
 
I normally do this by running the macro then actually go into the edi
macro, copy it and then, edit the CMD button code and paste it in here
 
Hi

Buttons from the Forms toolbar behaves like you're used to. The ones from
the Controls toolbox has a macro already. In design mode, rightclick it, go
View Code and you'll see

Private Sub CommandButton1_Click()

End Sub

Call your macro from there, like

Private Sub CommandButton1_Click()
Call FormatMySheetMacro
End Sub
 
Harald, yes it worked perfectly fine you saved my day thank you an
thank you engmgriff
 
excellover > said:
Harald, yes it worked perfectly fine you saved my day thank you and
thank you engmgriff.
Click to expand...

Glad to hear that. Thanks for the feedback.

Best wishes Harald
Followup to newsgroup only please
 
Back
Top