Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
shift and down keys in macro | Excel Discussion (Misc queries) | |||
Macro to shift | Excel Discussion (Misc queries) | |||
Macro to shift to next row | Excel Worksheet Functions | |||
help with VB/Macro to shift cells | Excel Discussion (Misc queries) | |||
help with VB/Macro to shift cells | Excel Discussion (Misc queries) |