I have a problem with paths for Excel macros. I have a workbook I need to copy and move. Several people in different departmens are using this so I cannot implement the macros in PERSONAL.XLSB. I need to be able to update them and they have to be part of the sheet. My problem is that although I enter ExcelBook.xlsm!ThisWorkBook.Macro and save it, when I copy/move it and opens it again and try to run the macros, they have changed path to \\server\path\ExcelBook.xlsm!Macro and that doesn't work. I need them to be as I entered them.