Roger,

Immediate way

Application.Run "Work"

Better way,

set a reference to the addin in ToolsReferences, and then just call it like
any other sub.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Roger" wrote in message
...
I have created an addin from a sub() that I wrote in vba.

Now I want to create a button that runs the sub.

What must I put in the macro run box?

Addin name : addin
Project name : project
sub name : work()

Thanks