Personal.xls has to be open always to use it's macro.
See my answer in your previous post, where to store Personal.xls

Sharad

"kd" wrote in message
...
Hi All,

I am a newbie with repect to working on excel macros.

I have succeeded in recording a macro and stored it in 'Personal Macro
Workbook' as indicated by the excel help to make it available to all
workbooks.

When I open a new workbook however, the macro is not shown in the
available
macros list and so I am not able to execute it!

Can anybody help me?

Thanks.
kd.