Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
shift and down keys in macro CousinExcel Excel Discussion (Misc queries) 3 January 15th 10 02:05 PM
Macro to shift Unique713 Excel Discussion (Misc queries) 3 December 18th 08 08:59 PM
Macro to shift to next row Unique713 Excel Worksheet Functions 2 November 25th 08 05:51 PM
help with VB/Macro to shift cells [email protected] Excel Discussion (Misc queries) 3 May 3rd 06 08:03 PM
help with VB/Macro to shift cells dan Excel Discussion (Misc queries) 0 May 3rd 06 07:55 PM


All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"