I am trying to use AppActivate to reset the focus to Excel.

When the workbook is not maximized and the title bar says Microsoft Excel
AppActivate ("Microsoft Excel") works fine.

If the workbook is maximized the above does not work.

The file name is Dashboard_v2441.xlsm and the title bar reads:
Dashboard_v2441.xlsm - Microsoft Excel
(when maximized).

Can someone please provide the exact syntax I would need to get this to work
reliably when maximized, with paren/quotes if needed?

Also, if there are any other considerations/tricks to get the focus reset
reliably, I would appreacte a note.

Thanks,

Have you tried

AppActivate Application.Caption

?

Assuming this code is running in Excel.

Tim


"Tom Joseph" <(E-Mail Removed)> wrote in message
news:964BBA71-F8C8-42B2-BE3A-(E-Mail Removed)...
>I am trying to use AppActivate to reset the focus to Excel.
>
> When the workbook is not maximized and the title bar says Microsoft Excel
> AppActivate ("Microsoft Excel") works fine.
>
> If the workbook is maximized the above does not work.
>
> The file name is Dashboard_v2441.xlsm and the title bar reads:
> Dashboard_v2441.xlsm - Microsoft Excel
> (when maximized).
>
> Can someone please provide the exact syntax I would need to get this to
> work
> reliably when maximized, with paren/quotes if needed?
>
> Also, if there are any other considerations/tricks to get the focus reset
> reliably, I would appreacte a note.
>
> Thanks,
>