Personal Macro Workbook mystery

[Misca]

I've got a macro stored in my Personal Macro Workbook. What it does is basically open a workbook and add a new row to the existing table.

It works perfectly if I run it using any other way but using the shortcut keys. The macro still opens the workbook using the shortcut keys but it doesn't make any changes to the worksheet.

I have no idea why this happens or how to solve this. Any help would be appreciated for I'd prefer to use the keys to run it.

 

[Fluff]

Without knowing exactly what your code is, what workbooks are open & what is active at any moment in time. It's very difficult to help, but I have never encountered the problem you are getting & suspect that it has something to do with using select.

 

[Misca]

Thank you for your help.

I've tried commenting the ".Select" part and everything else I can think of. No effect: The code runs perfectly as long as it's not triggered through keyboard shortcuts.

Actually, I've managed to locate the problem. It seems to have something to do with the Shift key in the keyboard shortcut. If I set it to Ctrl + "e" it runs perfectly to the end. But if there's the Shift key in the shortcut the code runs to the Set WB row and ends on that line. Even if that line is put inside an if statement with End If being the very next line after that.

I even tried adding simple error handlers to the code: No effect whatsoever. The code does not error. It just stops running at the Workbooks.Open line as if it was the last line of code. If I disable the events at the start of the code it never reaches the end of the code where they'd be enabled again. And it doesn't matter if I set the WB to a variable or not: Workbooks.Open is the last line of code it reads when using the Shift in the keyboard shortcut.

I'm pretty happy with the code running perfectly from the keyboard shortcut without the Shift key but it would be interesting to know what it is in the Shift key that changes the code behavior.