Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro is not responding
Hi all,,,,,,,can someone help with this please, I have a macro but it does
not show up under the TOOLS, MACRO, menu, the only way to to see the code is to choose the VBA Editor and select the module and view code, but even then I cannot do anything with it, if I click step into nothing happens. Hopefully you can help. Cheers Len |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro is not responding
Make sure its a sub and not a function. Make sure it is not private.
-- Gary''s Student - gsnu2007c "Len Case" wrote: Hi all,,,,,,,can someone help with this please, I have a macro but it does not show up under the TOOLS, MACRO, menu, the only way to to see the code is to choose the VBA Editor and select the module and view code, but even then I cannot do anything with it, if I click step into nothing happens. Hopefully you can help. Cheers Len |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro is not responding
As ALWAYS, post your code for comments.
-- Don Guillett Microsoft MVP Excel SalesAid Software "Len Case" wrote in message ... Hi all,,,,,,,can someone help with this please, I have a macro but it does not show up under the TOOLS, MACRO, menu, the only way to to see the code is to choose the VBA Editor and select the module and view code, but even then I cannot do anything with it, if I click step into nothing happens. Hopefully you can help. Cheers Len |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro is not responding
If the macro is Private...
Private Sub MyMacro -or- If the macro uses arguments... Sub MyMacro(Arg1, Arg2) Then the macro will not appear in the Tools | Macro listing. If the macro uses arguments you will not be able to run it. You will have to call it from another sub and supply the arguments in the call... Call MyMacro(23Skido, BeesKnees) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Len Case" wrote in message Hi all,,,,,,,can someone help with this please, I have a macro but it does not show up under the TOOLS, MACRO, menu, the only way to to see the code is to choose the VBA Editor and select the module and view code, but even then I cannot do anything with it, if I click step into nothing happens. Hopefully you can help. Cheers Len |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro is not responding
Post the macro as it is written.
Maybe it is event code in a Worksheet or Thisworkbook Gord Dibben MS Excel MVP On Wed, 09 Jan 2008 18:30:06 GMT, "Len Case" wrote: Hi all,,,,,,,can someone help with this please, I have a macro but it does not show up under the TOOLS, MACRO, menu, the only way to to see the code is to choose the VBA Editor and select the module and view code, but even then I cannot do anything with it, if I click step into nothing happens. Hopefully you can help. Cheers Len |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro is not responding
Thanks Guys, you put me on the right track. The top of my code read: Macro3(Pairs). So knocked out the Pairs so it read Macro3(). Thanks to all for your Help Len "Jim Cone" wrote in message ... If the macro is Private... Private Sub MyMacro -or- If the macro uses arguments... Sub MyMacro(Arg1, Arg2) Then the macro will not appear in the Tools | Macro listing. If the macro uses arguments you will not be able to run it. You will have to call it from another sub and supply the arguments in the call... Call MyMacro(23Skido, BeesKnees) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Len Case" wrote in message Hi all,,,,,,,can someone help with this please, I have a macro but it does not show up under the TOOLS, MACRO, menu, the only way to to see the code is to choose the VBA Editor and select the module and view code, but even then I cannot do anything with it, if I click step into nothing happens. Hopefully you can help. Cheers Len |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Not Responding | Excel Discussion (Misc queries) | |||
Excel not responding | Excel Discussion (Misc queries) | |||
excel not responding | Excel Discussion (Misc queries) | |||
Excel is not responding. | New Users to Excel | |||
Excel - Not responding help | Excel Discussion (Misc queries) |