macro in every workbook - Personalize

[gsrikanth]

Can i run my macro in every new workbook. or in already existing workbook.
Can any body help in personalize?
Thankyou

 

[ranman256]

Record a macro, select PERSONAL workbook,
click any cell, stop recording,
enter VBE (alt-F11)
open module1 in personal wb, remove the macro made above,keep module.
copy your macro needed from the source workbook to the personal workbook,module1.
save

now the macro will work in any wb.