Dimm

You could use something like this in the 'ThisWorkbook' module

Private Sub Workbook_Open()
ActiveWindow.Zoom = 100
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"dimm" wrote in message
...
Hi,

I'm wondering what the code is to specify that the Excel zoom level be at
100% when my workbook opens?

Any ideas?