Hi Josie

I wasn't aware of that, thanks for the info. That's a bit of an esoteric action to have squirreled away, but I can see how it makes sense outside of my requirement and looks like that'll be the reason for my issue.

Have to say, though, that it does seem a bit odd that the SHIFT modifier must be explicitly defined as a macro keyboard shortcut (i.e. if your shortcut is normally Ctr+E you can't add SHIFT to invoke it with this block on), yet the SHIFT still retains that "block" property throughout the invocation of the macro. But, hey, it's Microsoft code, so anything is possible.


@Tony - Thanks for all your help, sir, but if it is the action as Josie mentioned above then I think we're at the end of the hunt. However you've shown me some really useful ways to debug my macros whilst ironing them out, and that is always much appreciated.

BTW, for completeness I did what you said anyway, and can confirm that the debug only recorded the proper line for opening he document by name:

About to open workbook "C:\Users\steve\Documents\Templates\Excel\130903-master.xltx"


So thanks both - I will mark this thread as SOLVED.

KR

Steve