A
andy
i have a workbook that i use as a template. i am using the save as option in order not to change any of the data on it. However, whenever i save it under a different name the macros that i have set up seem to want to open the original book and do the selected action in there. is there a way to get the macros to work in all books without having to refer to the original file? i can get the macros to work if i reassign the buttons, but this is quite annoying. any light on the matter would be great!