ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Shift+Shortcut Key does not work (https://www.excelbanter.com/excel-programming/277123-shift-shortcut-key-does-not-work.html)

Allen[_7_]

Shift+Shortcut Key does not work
 
Hi,

I have a macro which opens several workbooks.
If I run it from the menu system or from a button on a
toolbar or on a worksheet, it runs fine.
If I assign it a shortcut key CTRL+KEY, it works fine.

If I assign it a shortcut key CTRL+SHIFT+KEY, it only
opens the first workbook and does nothing else.

Why is the shift key causing that problem? It would be
nice to know.

Thanks,

Allen



Jim Rech

Shift+Shortcut Key does not work
 
When you open a workbook with Shift down it stops auto running macros.

--
Jim Rech
Excel MVP



Allen[_6_]

Shift+Shortcut Key does not work
 
Thanks Jim, that is helpful to know. Will be useful for
opening workbooks too.

Allen

-----Original Message-----
When you open a workbook with Shift down it stops auto

running macros.

--
Jim Rech
Excel MVP


.



All times are GMT +1. The time now is 12:39 PM.

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