I have created a workbook and saved it as Test.xls
In this workbook I have macros that drive certain functions of the various worksheets and attached these macros to a custom Toolbar. I saved them in the current workbook not in Personal.xls
My problem is when I save the workbook to a different file name and use the custom Toolbar I created with the macros it wants to load the file Test.xls to execute the macros.
How do I make the macros reference the active workbook I am working on and not reference the workbook that the macros were originally created in
