ExcelBanter - view 100%

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - view 100% (https://www.excelbanter.com/excel-programming/335137-view-100%25.html)

Bob Phillips[_7_]

view 100%

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

Jacob

view 100%

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

All times are GMT +1. The time now is 11:52 PM.