Where to save a maco

[j252ewv]

I have been tasked with the following:

Add a button to excel that when pressed will export a subset of data to a new excel spreahseet.

I know how to add a new toolbar and button to excel and even how to attach a macro to the button. My question is how do I store the said macro in such a way as when excel runs up the button always knows where to find the macro to run.

I hope this makes sence

Thanks in advance.

 

[PHV]

Why not in your personal.xls(b) ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886