VSTO 2010 add-in doesn't open in a full-screen window

Question

we have created a VSTO Excel workbook with VS2010, .NET 4.0. After we publish and install the xlsx document, it opens up as expected for the first time. Then we run some operation using the plug-in and save the workbook. After closing and reopening it again, the Excel frame opens full screen but the workbook opens in a small window that can not be re-sized.

     We have tried the following code on the following workbook events : Activate, Startup, Open 

Application.WindowState = XlWindowState.xlMaximized;
Application.ActiveWindow.WindowState = XlWindowState.xlMaximized;

Same result, the workbook opens in a small window that is not re-sizable. We would like for the workbook to open full screen.

Please submit recommendations/ideas.

Thank you.

score 1 · Answer 1 · edited Mar 06 '12 at 22:33

1

This will work:

private void ThisWorkbook_Startup(object sender, System.EventArgs e) {
    Globals.ThisWorkbook.Application.WindowState = XL.XlWindowState.xlMaximized

edited Mar 06 '12 at 22:33

answered Mar 06 '12 at 15:35

VARINDER CHHABRA

11
1

score 1 · Accepted Answer · answered Mar 26 '12 at 18:32

1

The problem was in the workbook having structure protection in place and I had to disable that before saving the workbook, putting the protection back after the save operation is complete. Thank you.

answered Mar 26 '12 at 18:32

itisinteresting

125
2
12

score 0 · Answer 3 · answered Jan 30 '12 at 13:34

0

try

Application.ActiveWindow.ActivateNext();
Application.ActiveWindow.WindowState = XlWindowState.xlMaximized

answered Jan 30 '12 at 13:34

Brijesh Mishra

2,738
1
21
36

VSTO 2010 add-in doesn't open in a full-screen window

3 Answers3