Attaching a macro (module) code to button

[Todd Huttenstine]

Below is a code that creates a button on the Worksheet
menu bar. But how do I programmatically assign
module "createbutton" to it?

Also where can I find more info about programmaticaly
creating buttons on Excel Toolbars?

Thanx
Todd Huttenstine

Application.CommandBars("Worksheet Menu Bar").Controls.Add
Type:= _
msoControlButton, ID:=2950, Before:=11

 

[Rob van Gelder]

You're looking for the OnAction property.

You can do a help search for commandbar.