How to make the vba macro which can be used in every excel file?

[woshichuanqilz]

I find that the customize macro seems follow a specific excel file. But I have my micro which can be used in many excel file like change the font or center the cell content. I don't want to create the same macro in the different files, that so boring. Any way to create the general macro?

[quanluuvan]

I find that the customize macro seems follow a specific excel file. But I have my micro which can be used in many excel file like change the font or center the cell content. I don't want to create the same macro in the different files, that so boring. Any way to create the general macro?

Hi,

You can make it as add in so you can do in many excel files

[alansidman]

Look at this link

https://www.rondebruin.nl/win/personal.htm