Macros Stop Working

[drewg]

Hi board;
An application opens with a dialog that lets the user select a folder to work in, then copies some materials workbooks of one worksheet each and one master workbook that lets users select as many materials as needed and include it in the master workbook. They edit the materials as needed in the master workbook in the project folder, adding new worksheets of materials as needed.
Each materials workbook has navigation buttons referencing macros in Personal that move the cursor around in the materials worksheet.
If i open a materials workbook in a new project folder, the navigation buttons find Personal and the buttons do what they are expected to do.
However.
If I open the master workbook with a copy of the materials worksheets that have been added to master, the navigation buttons on the imported materials worksheets do not work.

My theory is that the materials navigation button macros work because they are aware of the workbook they come from, but when they are copied to the master, they lose their material workbook identity because they are no longer part of the materials workbook, they are now part of the master and the macros are no longer hooked to Personal?
My question is, how can i restore the functionality of the navigation buttons in the materials worksheet once it is imported into the master?

Thanks very much

 

[mole999]

If you were to start a new macro button using assign macro and look at the naming construct, it might show a static path

 

[drewg]

thanks very much for your reply
I will do that and see if I understand what needs to happen to get it to go...I'm guessing i need to use your clue about the static path (its somewhere in either the button macro or in Personal, I'm not sure) and change that path to Application.ThisWorkbook.Path, or maybe Application.ActiveWorkbook.Fullname since, based on observations that it works in the materials but not in the master, it is the name property that is getting clobbered in the copy?
Thanks very much, I will try to figure out where the reference is (in the materials workbooks or in Personal) and look for a static path in the button code to change to one of the above, and hope that gets me home.