Holding the shift key down when you open a workbook disables the auto run macros
(workbook_open and auto_open).

If it's in the shortcut, it confuses excel so that it thinks it shouldn't be
running macros. So your "real" macro stops.



Dave Unger wrote:

Hi Dave

On Feb 18, 8:52 am, Dave Peterson wrote:
Remove the shift key from your short cut key combination.

I just ran into a similar situation, and discovered that removing the
shift key fixed the problem. But I was unable to come up with a
"why". Then I came across your reply, and I'm hoping you could
explain the "why" to your solution. Thanks,

Regards

Dave U.

--

Dave Peterson