I'm hoping this is just a simple answer, I don't know much about Excel macros, but couldn't find exactly what I was looking for searching on EE. When I add a macro button such as the pic below.
The button is added globally in my excel. But if I create a new excel document, click my new facy macro button, it opens up the original excel document and executes on that. So what I'm asking is how do I make a global macro in Excel 2007? Thanks!