Need workbook to open to consistent size

[RonRich]

Would like the workbook to open to a consistent X and Y size regardless of its size the last time it was saved. This would allow the initial worksheet to always have the same appearance. I find no attribute of WorkbookOpen that does this. This topic nay havebeen discussed before but could not do a search to find it.
Any suggestions? Thanks - Ron

[:) Sixthsense :)]

I believe you are talking about the sheet zooming size

Add the below code in This Workbook Code Window

To Add Excel VBA Code to a Workbook / This Workbook Module

1. Copy the code that you want to use
2. Select the workbook in which you want to store the code
3. Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
4. In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
5. Right-click on the ThisWorkbook object, and choose View Code
6. Where the cursor is flashing, choose Edit | Paste

Please Login or Register  to view this content.

[RonRich]

Thanks Sixthsense! I was actually thinking of the size of the Excel workbook outer dimensions. However, your solution is better in that the content of the worksheet does appear properly. I have 12 similar worksheets in the workbook (one for each month). Could you suggest the best way to modify your code so that it will set each worksheet when selected (active sheet) to the same % (I found 90% perfect)?? Each worksheet has a separate name of course (Jan, Feb, etc.). I could try to work in a series of IF statements - one each month - but perhaps there is a better way. Still learning here.
Thanks - Ron

[:) Sixthsense :)]

Replace the below code with the previously suggested code

Please Login or Register  to view this content.

[RonRich]

That did it Sixthsense. Thanks ever so much. Now each worksheet opens at 90%.