Record Macros to run on all sheets?

[Roses48]

Ok all I'm hoping you can help. I am not new to excel but I am extremely new to Macros. Currently in my office we use a finance form that has a macro in it for automatically writing out a number when it's entered into a certain cell on this form. I'd like to find out who I can take this macro and save it so that I can use it in all my excel files. Right now it's only saved in the form. Also I have a second macro that I would like to find out how to do the same thing with. This macro merges cells using a keyboard short cut.
For some reason I can't seem to figure this out. The only way I can see the macros is by opening up visual basic in excel and recopying the information in the module to a new module.
Any help would be appreciated!

~Roses48

 

[doubledaffy]

Save the module to your PERSONAL excel workbook. Then you can access the macro no matter what sheet you open.

Take a look at this too: http://office.microsoft.com/en-us/e...l-macros-from-a-central-file-HA001087296.aspx

 

[Roses48]

Thanks that helped a lot! I found my personal.xlsb file and was able to save them to that.

 

[doubledaffy]

Glad to help!