Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie - macro help required urgently!
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie - macro help required urgently!
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie - macro help required urgently!
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie - macro help required urgently!
You can easily create Personal.xls.
Goto ToolsMacroRecord New Macro... In this dialog, in the Sore macro dropdown, choose Personal Macro Workbook Click the stop record button immediately (You don't need this macro) Go to the VBE then, and you will have a Personal.xls that you can move your previously recorded macro to. -- HTH RP (remove nothere from the email address if mailing direct) "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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie - macro help required urgently!
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie - macro help required urgently!
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help on merge urgently required | Excel Discussion (Misc queries) | |||
urgently required help | Excel Worksheet Functions | |||
Macro newbie | Excel Programming | |||
urgently required.. | Excel Programming | |||
Newbie formula help required pls | Excel Programming |