Zoom property error

L

Luis

I have a workbook with a chart and i have some VBA code to
format the chart, etc., but there is an instruction that
gives a Run Time error.
The instruction is "ActiveWindow.Zoom=100".

The error is:

Run-Time Error '1004'
"Unable to set the zoom property of the windo2 class."

Can someone help me solving this problem?
 
S

steve

Luis,

If the chart is selected you will get the error.

First select a cell and than run the zoom

Range("A1").Select
ActiveWindow.Zoom=100

or use this to select the cell under the chart

Range(ActiveChart.Parent.TopLeftCell.Address).Select
ActiveWindow.Zoom=100
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting a default zoom in Infopath 0
Drop down list control value in vba 2
Macro to change column width and active window zoom as columns areselected 0
Unable to set ColumnWidth property 3
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
screen resolution vs. zoom vs. activewindow 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
MS Project Import Error Row 1 Column 5 2

Top