ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   shift+(key) to run macro (https://www.excelbanter.com/excel-programming/276853-shift-key-run-macro.html)

Allen[_6_]

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

Tom Ogilvy

shift+(key) to run macro
 
don't use a shorcut key combination that contains SHIFT.

--
Regards,
Tom Ogilvy

"Allen" <1@1 wrote in message
...
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





All times are GMT +1. The time now is 06:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com