Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AppActivate syntax - help needed
Have you tried
AppActivate Application.Caption ? Assuming this code is running in Excel. Tim "Tom Joseph" wrote in message ... 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AppActivate syntax and question | Excel Programming | |||
VBA code to sum a row: syntax needed | Excel Discussion (Misc queries) | |||
Please explain syntax needed | Excel Programming | |||
Multiple Condition syntax needed | Excel Programming | |||
Syntax needed for With | Excel Programming |