How Can I Enable Recorded Macro to each New Workbook

[sgolwalkar4ever]

Dear All Experts,

I have recorded Macro for to convert centigrade to Fahrenheit chow can i enable this macro for each New Workbook. Actually I tried but results is none i read many books for that but not getting succeeds.


Book1.xls

Here with find the attached file for your ready reference.


With Best Regards,

[HaHoBe]

Hi, sgolwalkar4ever,

you could copy the code into your personal.xlsm or personl.xls for use (you could create either of these when recording a mcaro and change place for the macro accordingly).

FYI: the attachment canīt be loaded.

Update: no more problem with loading your workbook (must have been a problem with my browser who didnīt like to see your workbook)

Ciao,
Holger

[Andrew-R]

Excel already has an in-built function to convert centigrade to Fahrenheit, so you could just use that:

=CONVERT(D5,"C","F")