Hmm

I want to make it so that the user can run the program at
any time, from any workbook. As they get a dump from
another program and this will sort it out into how they
want it.

Maybe I just misunderstood what you said.. could you
re-word it please then :)

Thanks

-----Original Message-----
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


.