Hi Nikos,

"Nikos Yannacopoulos"
Code in add-ins is not run the same way as "local" (in the same workbook
or
in personal.xls) code. The button should be made to run a "local" macro ,
which runs the code in the add-in by means of a call like:
Run MyFunctionName
provided, of course, that the add-in is already loaded.

Thanks for the post. My .xla is stored in the alternate startup file
location and this file is checked in the add-ins list. How can I check that
it is loaded? When I try and open this xla file nothing happens (there was
no password set). This xla file was originally a xls file containing the
macros which I saved as an xla in the alternate startup file location and
then added it as an add-in.

Any advice appreciated,

Thanks, Tom.