ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Maximized or minimize (https://www.excelbanter.com/excel-programming/393359-maximized-minimize.html)

Philosophaie

Maximized or minimize
 
How to maximize an initially hidden Workbook:
Shell ("c:\Program Files\Microsoft Office\OFFICE11\WINWORD.exe", "Code to
mazimize or set visible=True")

JLGWhiz

Maximized or minimize
 
If I read the VBA help file correctly, this would maximize with focus.

Shell ("c:\Program Files\Microsoft Office\OFFICE11\ _
WINWORD.exe" ,xlMaximizedFocus)

"Philosophaie" wrote:

How to maximize an initially hidden Workbook:
Shell ("c:\Program Files\Microsoft Office\OFFICE11\WINWORD.exe", "Code to
mazimize or set visible=True")


JLGWhiz

Maximized or minimize
 
That should be vbMaximizedFocus, not xl.

"Philosophaie" wrote:

How to maximize an initially hidden Workbook:
Shell ("c:\Program Files\Microsoft Office\OFFICE11\WINWORD.exe", "Code to
mazimize or set visible=True")



All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com