Macros behave differnet when invoked by different methods

[Tonso]

Using XL 2003, i have recorded several macros. For example, i recorded
one that changes the "Move selection after Enter", to toggle the
selection either Up or Right. I created an icon, using the letter "Z"
to invoke it. When I click on the icon, the press Enter, the selection
will move as required. But, if i use Alt Z to invoke the macro, then i
have to press Enter 2 times. I have noticed this with other macros,
that when invoked using Alt + letter, then an extra Enter is required.
How can i eliminate the extra "Enter"?

Thanks...

Tonso

 

[Dave Peterson]

Just a guess...

If you use Z as the accelerator for more than one icon on your toolbar, excel
will cycle through all the icons.

Try watching the screen to see if you're looping through multiple icons with the
same accelerator shortcut key.

 

[Tonso]

Just a guess...

If you use Z as the accelerator for more than one icon on your toolbar, excel
will cycle through all the icons.

Try watching the screen to see if you're looping through multiple icons with the
same accelerator shortcut key.

Thanks Dave! That was the problem.

Tonso