The way to avoid Excel opening the original workbook when you run the macro is
to put the macro in your Personal.xls workbook and attach the button  to it
there. Search Google for 'personal.xls' and you will find all the information
you need, including this link to Linda Johnson's site:
http://personal-computer-tutor.com/personalxls.htm

You could distribute your macro as an Excel add-in. Search Google for 'create
Excel add-in' and you can choose from many tutorials on the subject.