xlApp.ActiveWindow.Zoom = 100

--
HTH

Bob Phillips

"Jacob" wrote in message
...
Hi all,

I use vb6 to create and show an excel sheet.
I want the view to be 100% but probably because the chart is too big -
excel
shows it in 44% when it opens.
How do I use VBA code to set it to 100% ?

TIA
Guy