View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Allen[_6_] Allen[_6_] is offline
external usenet poster
 
Posts: 2
Default shift+(key) to run macro

I have a macro that opens several different files.
It works fine.

To run the macro, I have assigned a shortcut key: ctrl+e
in the macro options dialogue box.
This works great.

However, if I assign shortcut key: ctrl+SHIFT+e (or any
other letter), the macro cuts out immediately after
opening just the first file.

Does anyone have any idea why this is? It is really
annoying me that I can't have ctrl+shift+e. (It is my
fifth general macro for my work and the others are a,b,c,d
and all wrok fine).

Cheers,

Allen