Apologies for replying on such an old post, but I'm curious why I can't make @SierraOscar's reply work.

I use Office 365 (in 32bit for old VBA) I understand about conditional compilation. F2 shows an Application method AppActivate

I've defaulted to Direct calls to User32, as per the OP solution. It works.

But how does one use Application.AppActivate successfully?

spilly