Set Zoom Level in Auto-Open Macro?
 

Hi,

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

Any ideas?

Set Zoom Level in Auto-Open Macro?
 

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?

Set Zoom Level in Auto-Open Macro?
 

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

L8rs.

"Nick Hodge" wrote:

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?