zoom button is blanked out

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

I am using Office 2000 SP3. I have problem zooming in the
charts in Excel. The zoom button is grey out on both
formatting bar and under view -> zoom. In order to zoom
in, I have to de-select "sized with window" under view.
Unfortunately, I have more than 10 charts in that
workbook. How can I change the setting at once?
 
You can set them all with a macro:

Sub SetChart()
Dim ch As Chart
For Each ch In ActiveWorkbook.Charts
ch.SizeWithWindow = False
Next ch
End Sub
 
Without a printer installed (or if Windows can't find the printer, for
example if a network printer is turned off), this selection is unavailable.

- Jon
 
Back
Top