One macro for all excel file

[JERRY89]

Dear all,
I do have a question, why is my macro command I set in one excel file supposed can be used for all other file but when I use this macro in other excel file it will open the first excel file created this macro

[HansV]

If you want a macro to be available in all workbooks, you must store it either in your Personal Macro Workbook PERSONAL.XLSB, or in an Excel add-in (a .xlam file).
If you store it in an ordinary workbook, Excel must open that workbook in order to run the macro.

See How do I create and use a PERSONAL file for my VBA code.

[JERRY89]

Hi Hans,
Thanks a lot for the assistance..