CommandBar

[questionit]

Hi

I have problem using .OnAction property of
[code=vb]
Set myCPBtn = myCPup1.Control s.Add(Type:=mso ControlButton)
With myCPBtn
.OnAction = "mySub"
End With
[/code]

[code=vb]
Public Sub mySub()
MsgBox ("Hello!")
End Sub
[/code]

I get error:
Microsoft can't run macro or callback function "mySub"


2- How can i make command bar unmoveable ?

Thanks
Qi

[zaidlig]

Create a macro named "MySub"