how to save a desired window size but hv window comeup fullsz by d

[smjm1982]

say I am creating a small list, I resize the window for that list and when I
save it, I want the desired window size to save for that purpose. However,
when I open a new empty celled window, I want it to open full size by default
since I do not know how much space i'll need for the next project.

Is it possible to have excel save a desired windowsize along with any one
given project but still open full size by default, can someone help me on
this one, thanks.

 

[Gary''s Student]

Here is an alternative. Say we want Excel to open full size, but set the
Zoom to the useful area in the small table. Include this small mcro in the
workbook code area:

Private Sub Workbook_Open()
ActiveSheet.UsedRange.Select
ActiveWindow.Zoom = True
End Sub