ExcelBanter - View Single Post - Macro fine Run fine from Select but not from KB Shortcut?

Dave Peterson

See the other response.

wrote:

Dave,

The Shortcut w/o the shift key worked.

Only if you have time (silly me) I would like to know about why the "open file" issue.

Thanks

Dave Peterson wrote:

Does your code open another workbook and fail right after it opens that
workbook?

Does your shortcut key include the shift key?

If yes, then remove the shiftkey from the shortcut key combination.

Holding the shift key while opening a workbook stops the open macros
(workbook_open/auto_open) from running. And it can confuse excel enough so
that it doesn't know to continue with the remainder of your original code.

This is a problem with xl2003 (and below). I don't use xl2007 to know for sure.

If this doesn't help, I think you'll have to give more info.

wrote:

2003 & 2007

What could cause a macro fine run fine from "Select Run" but not from KB Shortcut?

Just in case, I changed the KB Shortcut but still the issue.

BTW same result on different computers.

Any thoughts appreciated!

EagleOne

--

Dave Peterson