Do you have two instances of excel started? If so, you need to work in only
on instance of excel.

--
Regards,
Tom Ogilvy

"kd" wrote in message
...

Thanks for the response.

Personal.xls does not show up in the drop down list of the new workbook,
where I want the macro to run; however, the personal.xls is shown in the
drop
down list of the workbook where I recorded the macro.

I can see the recorded macro in the visual basic editor.

Regards,
kd

"Tim Williams" wrote:

Does personal.xls show up in the drop-down list in the macros dialog
(the one that pops up if you press Alt+F8) ?

If you go the the visual basic editor (Alt+F11) can you see the
recorded macro?

Tim


"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.