anyone got any simple code that can add a macro button onto

LMF · Apr 16th, 2002, 03:48 PM

i saw one that is really long, has any1 got a short piece of code, that will add a custom button onto the toolbars????

macro button

pls lmk

Scott · Apr 16th, 2002, 03:53 PM

Try this:

Sub AddButton()

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 03:48 PM	#1
LMF Board Regular Join Date: Mar 2002 Posts: 73	i saw one that is really long, has any1 got a short piece of code, that will add a custom button onto the toolbars???? macro button pls lmk

Apr 16th, 2002, 03:53 PM	#2
Scott New Member Join Date: Feb 2002 Location: McKinney Texas Posts: 6	Try this: Sub AddButton() Application.CommandBars("Worksheet Menu Bar").Controls.Add Type:= _ msoControlButton, Id:=2950, Before:=11 End Sub