To code something to happen when you open a workbook, take a look at
Workbook_Open in the VBA help

OR

See the various 'Open Events' at Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

As far as the sizing of the window:
Application.WindowState = xlNormal
Application.Width = 717
Application.Height = 487.5

HTH--Lonnie M.