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.

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.