Shift+Shortcut Key does not work

[Allen]

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]

When you open a workbook with Shift down it stops auto running macros.

 

[Allen]

Thanks Jim, that is helpful to know. Will be useful for
opening workbooks too.

Allen