I have created an .xla file with all sorts of functions that I want to use from an .xls file. The .xla file is added as an Add-In in Excel. In the .xls file I have a number of command buttons that are supposed to run the functions in the .xla file. In the "assign macro" dialog of the comman buttons I have just specified the function name of the function contained in the .xla file.
This seems to be working fine but problems arise when I move the .xls file to another directory. For some strange reason the new path is added to the macro path in the command buttons when I do this even though the .xla file is an Add-In and already loaded. That is... First the macro is specified as "openMenu". When the .xls file is moved to another directory this is updated to: c:\myNewDirectory\myXLAFile.xla!openMenu. This causes Excel to complain about that there is already one myXLAFile.xla open so it can not open another one eventhough myXLAFile.xla is not located under c:\myNewDirectory\.
This is driving me insane! Would really appreciate some help on this matter.
Thank you in advance