B
bw
I have placed macros on toolbar buttons, assigned them, and attached them to the
workbook.
I have saved the workbook as a template "TESTA.xlt".
When I select File, New to open "TESTA1.xls", and click on the macros, they work fine.
Now when I go back and open the template "TESTA.xlt", and click on one of the toolbar
macro buttons, I get the following message:
-----------
'TESTA1.xls' could not be found. Check the spelling of the file name, and verify that the
file location is correct.
If you are trying to open the file from your list of most recently used files on the File menu,
make sure that the file has not been renamed, moved or deleted.
--------
So I assign the macros to the buttons again, and they then work again for "TESTA.xlt".
I don't understand. Why do I have to keep assigning the macros?
Thanks,
Bernie
workbook.
I have saved the workbook as a template "TESTA.xlt".
When I select File, New to open "TESTA1.xls", and click on the macros, they work fine.
Now when I go back and open the template "TESTA.xlt", and click on one of the toolbar
macro buttons, I get the following message:
-----------
'TESTA1.xls' could not be found. Check the spelling of the file name, and verify that the
file location is correct.
If you are trying to open the file from your list of most recently used files on the File menu,
make sure that the file has not been renamed, moved or deleted.
--------
So I assign the macros to the buttons again, and they then work again for "TESTA.xlt".
I don't understand. Why do I have to keep assigning the macros?
Thanks,
Bernie