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

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

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

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

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

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