Zoom property error

  • Thread starter Thread starter Luis
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

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 zoom of a worksheet in macro 3
Zoom problem 2
Tab Code Retrieve a Value 3
Unable to set ColumnWidth property 3
Already Zoomed Out as Far as Possible 0
Pagesetup Property error in excel 1
Chart zooming 2
Prevent Extreme Zoom Out. Mouse Wheel Event? 2

Back
Top