C
chet
In Excel2003 under WXPSP2, I have a series of procedures which
generate a lot of statistics and (line with markers and 3d column)
charts. Everything works fine and the charts are output as specified
in the vba code. But after I close workbooks and reopen them, excel
has reset several chart properties. First, the charts' property
.SizeWithWindow = False
and the window magnification
.Zoom = 100
were changed; excel had reset all the chart Views to Sized With Window
(checked) and Zoom to 127%. Thinking that this behavior might be set
by an excel option, I posted a query in the microsoft.public.excel
group, but have not received a response. After resetting these values
manually and reopening the workbooks, the specified size and zoom
properties have been (so far) persistent. This is reminiscent of the
issue in
http://groups.google.com/group/micr...es+after+reopen&rnum=2&hl=en#adb59c5dba04dd7f
Does this mean that a workbook_open macro must be written to reset
these properties on each reopen? (This first group of 20 charts is
just a test bed, and manually resetting these properties for all the
hundreds of future charts would be onerous.)
Are view properties NOT persistent when set via vba code? Is there an
application option that controls this behavior? Can these properties
be persistently set in vba code? Is a workbook_open macro the
solution to this problem?
Second, unlike the first problem which affects all charts uniformly,
excel resets other chart properties for some of the charts but not all
of them. For some (but not all) of the 3d column charts, excel resets
the
.Axes(xlSeries).TickLabelSpacing = 1
to 3 which forces the loss of a series label. Some of these charts
also have the
TickLabels.Font.Size = 9
reset to 10. Changing these back manually also is not persistent. Is
there a way to force excel to leave these properties as set in the vba
code?
Thanks for any help or suggestions.
generate a lot of statistics and (line with markers and 3d column)
charts. Everything works fine and the charts are output as specified
in the vba code. But after I close workbooks and reopen them, excel
has reset several chart properties. First, the charts' property
.SizeWithWindow = False
and the window magnification
.Zoom = 100
were changed; excel had reset all the chart Views to Sized With Window
(checked) and Zoom to 127%. Thinking that this behavior might be set
by an excel option, I posted a query in the microsoft.public.excel
group, but have not received a response. After resetting these values
manually and reopening the workbooks, the specified size and zoom
properties have been (so far) persistent. This is reminiscent of the
issue in
http://groups.google.com/group/micr...es+after+reopen&rnum=2&hl=en#adb59c5dba04dd7f
Does this mean that a workbook_open macro must be written to reset
these properties on each reopen? (This first group of 20 charts is
just a test bed, and manually resetting these properties for all the
hundreds of future charts would be onerous.)
Are view properties NOT persistent when set via vba code? Is there an
application option that controls this behavior? Can these properties
be persistently set in vba code? Is a workbook_open macro the
solution to this problem?
Second, unlike the first problem which affects all charts uniformly,
excel resets other chart properties for some of the charts but not all
of them. For some (but not all) of the 3d column charts, excel resets
the
.Axes(xlSeries).TickLabelSpacing = 1
to 3 which forces the loss of a series label. Some of these charts
also have the
TickLabels.Font.Size = 9
reset to 10. Changing these back manually also is not persistent. Is
there a way to force excel to leave these properties as set in the vba
code?
Thanks for any help or suggestions.