Hi Dave,

Oh, yes !! I'm ashamed to admit how much time I wasted over this,
troubleshooting some fairly complex code before stumbling on to the
cause. Oh well, live & learn!

Thanks for this, Dave.

Regards,

Dave U

On Mar 4, 12:30*pm, Dave Peterson wrote:
Holding theshiftkey down when you open a workbook disables the auto run macros
(workbook_open and auto_open).

If it's in theshortcut, 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 theshiftkey from your short cut key combination.

I just ran into a similar situation, and discovered that removing the
shiftkey 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