Malfunctioning AppActivate in Excel VBA 2016 for Mac is driving me nuts.
Anyone found a way to return to the Excel app having switched focus to, say Word, programmatically?
This triggers an error (works fine on a PC)
This triggers no error on a Mac but also has zero effect. (On a PC it causes an error, but that would be fine using conditional compilation).
AppActivate "Microsoft Excel"
I have experimented with simply minimising the Word window, but cannot then re-maximise it programmatically on a Mac either.
WordApp.ActiveWindow.WindowState = wdWindowStateMinimize
But this does not:
WordApp.ActiveWindow.WindowState = wdWindowStateNormal
I seem only to be able to restore Word manually once I've minimised it.