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

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

--
Jim Rech
Excel MVP

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


.