A good macro that works wrong with keyboard shortcut
 

I have a keyboard shortcut problem with a macro I have
recorded.

The macro opens and formats three text space delimited
files. I know the macro works OK because when I select it
with the mouse in the macro menu and hit Run it works fine.

Now I want to have a keyboard shortcut that will save me
the clicks in the menu. Using Options on the macro menu
allows me to enter a shortcut key (eg ctrl-shift-E).

But when I run the macro using ctrl-shift-E the macro only
works as far as opening the first file. It goes no
further and considers its job done. I don't understand
why this is.

Any ideas?

A good macro that works wrong with keyboard shortcut
 

Yes, the Shift part of your shortcut is causing he problem.

Use a shortcut key combination that does not involve Shift.

--
Regards,
Tom Ogilvy

"Allen" wrote in message
...
I have a keyboard shortcut problem with a macro I have
recorded.

The macro opens and formats three text space delimited
files. I know the macro works OK because when I select it
with the mouse in the macro menu and hit Run it works fine.

Now I want to have a keyboard shortcut that will save me
the clicks in the menu. Using Options on the macro menu
allows me to enter a shortcut key (eg ctrl-shift-E).

But when I run the macro using ctrl-shift-E the macro only
works as far as opening the first file. It goes no
further and considers its job done. I don't understand
why this is.

Any ideas?