Hi
I have created a customised toolbar using standard funtionality in Excel 2003 with few buttons linked to some macros. The toolbar has been setup in an excel Template workbook.
The macro assigned to the button says: Main
Everything works fine as long as I use the macro in the template.
One of the main macro i have in the file cut the workbook in different spreadsheets and save it in a different folder / different name and save it not as Template but as a normal workbook.
Once this is done, if i reopen the original template workbook, the link to the macro has changed 'C:\Documents and Settings\Username\Desktop\Testing\Testing Template\Talent_Pack_Final_test.xls'!Main
I am wondering if it is possible to stop excel doing because i have each time the need to recreate the links of the button to the macro in the template
Hope the above make sense
Thx
L.
I have created a customised toolbar using standard funtionality in Excel 2003 with few buttons linked to some macros. The toolbar has been setup in an excel Template workbook.
The macro assigned to the button says: Main
Everything works fine as long as I use the macro in the template.
One of the main macro i have in the file cut the workbook in different spreadsheets and save it in a different folder / different name and save it not as Template but as a normal workbook.
Once this is done, if i reopen the original template workbook, the link to the macro has changed 'C:\Documents and Settings\Username\Desktop\Testing\Testing Template\Talent_Pack_Final_test.xls'!Main
I am wondering if it is possible to stop excel doing because i have each time the need to recreate the links of the button to the macro in the template
Hope the above make sense
Thx
L.