Excel macro stalls when executing from keyboard

[medic5678]

Hi everyone! I have written a macro which works perfectly except it hangs when I execute it from the keyboard. In this macro, I open an excel file and update it, then save it and close it. When I start it from the keyboard, it opens the file to update, then simply quits. The active window and worksheet is the file I opened. Any idea why it should behave differently based on how you start it? I have just changed the hotkey combination from ctrl +shift + W to ctrl + g. Works fine from the keyboard now. Anyone know what's going on with this? Thanks!

 

[Anthony47]

If you open a file while keeping the Shift key pressed (as to obtain W) then the new file opens but is macro are disabled. This explain why using "g" (low case) works

Bye

 

[medic5678]

I never though about the shift key interacting with the letter you are pressing. Funny that excel would steer you that way when assigning hotkeys to macros.

 

[RoryA]

It's a bug, really, and only occurs if your macro is opening other workbooks. See Jan Karel's article here: Excel: Workbook Open Bug