This seems like a trivial thing but I cannot get this to work properly.
I have created an XLT file that the firm is going to use as the default for all future Excel files.
This XLT file has buttons on a new toolbar, and those buttons are linked to macros in the Workbook. One macro, for example, sets the cell formatting a specific way.
Here's the problem:
When a new file is opened off the XLT file, the buttons "forget" the macros that they are linked to and no longer function. The error is: The macro "C:\Program Files...\XLSTART\Book1'ThisWorkbook.MyFormat' cannot be found.
Any ideas?
I have created an XLT file that the firm is going to use as the default for all future Excel files.
This XLT file has buttons on a new toolbar, and those buttons are linked to macros in the Workbook. One macro, for example, sets the cell formatting a specific way.
Here's the problem:
When a new file is opened off the XLT file, the buttons "forget" the macros that they are linked to and no longer function. The error is: The macro "C:\Program Files...\XLSTART\Book1'ThisWorkbook.MyFormat' cannot be found.
Any ideas?
