Macro is not responding

  • Thread starter Thread starter Len Case
  • Start date Start date
L

Len Case

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
 
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
 
Post the macro as it is written.

Maybe it is event code in a Worksheet or Thisworkbook


Gord Dibben MS Excel MVP
 
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
 
Back
Top