Put this in the Workbook_open event of the ThisWorkbook module

Sub zoomem()
Sheets.Select
With Sheet1
.Activate
ActiveWindow.Zoom = 75
.Select
End With
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Seanie" wrote in message
...
How would I Zoom all sheets to 75% when particular file is opened?

Thanks