View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
 
Posts: 391
Default Macro fine Run fine from Select but not from KB Shortcut?

(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?