Maximize Excel When Workbook Opening

[niuyuer]

http://www.vbaexpress.com/kb/getarticle.php?kb_id=556

The code does not work, anyone know how to maximize excel when opening? It does not have to be VBA, if there is setting somewhere.

Thanks,

[gmr4evr1]

Two questions...
1) Is the workbook protected? If so, unprotect it
2) Did you put the code from the link in the workbook or sheet module? It worked fine for me in the workbook module, but did not work when I put it in the sheet module.

[niuyuer]

Two questions...
1) Is the workbook protected? If so, unprotect it
2) Did you put the code from the link in the workbook or sheet module? It worked fine for me in the workbook module

Yes, it is protected, and I NEED to protect the workbook. Any other alternatives to open a protected workbook in maximized window?


Workbook module


See the attached screenshot.

error.jpg

Thanks much!

[niuyuer]

Never mind, I found the solution.

Adding two lines of code. One line (unprotect workbook by VBA) at the beginning, another line (protecting workbook) at the end.

Thanks.

[gmr4evr1]

Yup, that's what I was going to suggest....glad you got it figured out.