View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Joseph Tom Joseph is offline
external usenet poster
 
Posts: 51
Default AppActivate syntax - help needed

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,