zoom button is blanked out

[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?

 

[Debra Dalgleish]

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

 

[Jon Peltier]

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