Macros behave differnet when invoked by different methods

  • Thread starter Thread starter Tonso
  • Start date Start date
T

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
 
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.
 
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.
Click to expand...

Thanks Dave! That was the problem.

Tonso
 
Back
Top