Its a long while I have this problem and found no solution: I have an excel file containing macros that are run clicking a button from the toolbar. Somehow the macros are there identified with their absolute path ('C:\WINDOWS\Desktop\Cartel1.xls'!Macro1). So if I move the excel file somewhere else on the network or even on the same drive, and try to click the button to run the macro, I will get an error message (caused by excel looking for the old path). Is there any way to avoid this? For example telling excel to use relative paths?
Thanks in advance for your help.