Macro from 2003 to 2007
 

I set up several macros on a number of buttons in XL2003, works fine, within
a workbook. Part of the function is to creat a copy of a couple of tabs in
another workbook, which is smaller and easier to e-mail.
However in 2007, once a macro has run, the button(s) then refer to the
macro(s) as if it was in the new workbook, when this patently is not the case.
Getting to wits end