Thread
:
Macro fine Run fine from Select but not from KB Shortcut?
View Single Post
#
7
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
Macro fine Run fine from Select but not from KB Shortcut?
This issue is still this:
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.
Since your shortcut key includes the shiftkey, excel thinks that it should stop
the auto_open/workbook_open procedures in the newly opened workbooks from
running. And since it stopped those procedures, it's gonna stop the rest of
yours, too. (That's the confusion part.)
wrote:
(Gary's Student) Since I have switched keys that should not be the issue.
Thanks for our thoughts
Hello Dave,
Does your code open another workbook and fail right after it opens that
workbook? YES
Does your shortcut key include the shift key? YES
Got your thoughts on the "Shift" key.
What is the issue "open another workbook?"
In fact, the macro opens a text file using an array which is ultimately Saved As .xls
EagleOne
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?
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson