How to Alt-Tab when using (Mac to PC) Microsoft Remote Desktop?

[9tanstaafl9]

I am traveling and trying to use my Mac to edit workbooks on our server. Everything works fantastically, except whenever I Alt-Tab it goes back and forth between the server and my Mac programs, instead of alt-tabbing between the open Excel documents and the VBE editor. This driving up my blood pressure to dangerous levels. Does anyone know any way (short of using a PC or a fancy mouse) to make the alt-tab restrict itself to the remote session?

Note I am aware that I can choose FN Option F11 to open the VBE editors but I've been finding that way too difficult to execute. I would be willing to remap some keys to open the editor, but I don't know how to do that when using Remote Desktop.

Any advice appreciated. I would even appreciate search terms I might be missing to look for this. Whenever I search the terms seem to be too general and I get unrelated articles.

 

[JimM]

Not sure it's going to help but Ctrl + F6 also switches between workbooks

 

[9tanstaafl9]

Unfortunately, I touch type and use a lot of keyboard shortcuts. I'd love a solution that doesn't involve taking my eyes off the screen. That combo is a bit too complicated to do without looking. I would just practice it over and over until I had a muscle memory for it, but I use a MacBook without physical key for the F keys, so I can't manage to do it without looking.

Thank you though for the suggestion! It is helpful, just not what I'm looking for.