menu calling function

[PF]

Hi guys,

i am using

Set CTRL(3) = newmenu.CommandBar.Controls.Add(TYPE:=msoControlButton,
id:=3)
With CTRL(3)
.Caption = "Employés"
.TooltipText = ""
.Style = msoButtonCaption
.OnAction = "macMnuEmp"
End With

to call a macro macMnuEmp.

i would prefer to call a fucntion instead of a macro
since the macro is calling a single function

is there a way to do that?

..onaction = myfct() dont work

Regards
pierre

 

[Ken Snell [MVP]]

Try

.OnAction = "=myfct() "

 

[PF]

great !!

Try

.OnAction = "=myfct() "