Many moons ago I use to know how to do this - I can remember how t
record the macro - but despite all my efforts I can not link the macr
to a control button.

I am using Excel 2003

Any help would be gratefully received - and it is christmas

Thanks

Catdatama

--
Message posted from http://www.ExcelForum.com

Hi

Those buttons are from the Forms toolbar -rightclick them and assign macro.
Or you can use almost any shape from the drawing toolbar as a clickable
button, rightclick and assign macro. For the Control Toolbox buttons, they
have code already. Rightclick, choose "view code" and call your macro from
the

Private Sub CommandButton1_Click()
Call Macro1
End Sub

--
HTH. Best wishes Harald
Followup to newsgroup only please

"catdataman" skrev i melding
...
Many moons ago I use to know how to do this - I can remember how to
record the macro - but despite all my efforts I can not link the macro
to a control button.

I am using Excel 2003

Any help would be gratefully received - and it is christmas

Thanks

Catdataman


---
Message posted from http://www.ExcelForum.com/

Thankyou very much, worked a treat


---
Message posted from http://www.ExcelForum.com/

You're welcome, glad it worked. Thanks for the feedback.

Best wishes Harald
Followup to newsgroup only please.

"catdataman" wrote in message
...
Thankyou very much, worked a treat