Set Zoom Level in Auto-Open Macro?

[dimm]

Hi,

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

Any ideas?

 

[Nick Hodge]

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
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[dimm]

Thanks Nick, I'll try that tomorrow, its late here and I've gotta get some
sleep now! ;-)

L8rs.