Call procedure from another Excel File?
 

I need protected code that can be used by anyone accessing this excel file
but for the life of me, I can't seem to run a public sub from the other
workbook? I created an Add-in from the protected code workbook and added it
to my references but still no joy. Running Office 2003.

Thanks.

Call procedure from another Excel File?
 

Are you using

application.Run "MyAddin.xla!MyMacroName", arg1, arg2

and MyAddin is loaded?

--
Regards,
Tom Ogilvy

"Dave Ladd" <Dave wrote in message
...
I need protected code that can be used by anyone accessing this excel file
but for the life of me, I can't seem to run a public sub from the other
workbook? I created an Add-in from the protected code workbook and added
it
to my references but still no joy. Running Office 2003.

Thanks.