Strange Chart behavior when replaying recorded macro. For example from the 4 grid line option only 2 can be activeted through VBA. Why?

[Jamualson]

I have strange problems when replaying the macro I recorded. The a) is about the inability to select all 4 type of gridlines at the same type and b) and c) is about showing either an error message or recording a single but irrelevant line. Thank you very much if you have an idea for any of these. Have a nice day



a) I wanted to add all 4 type of gridlines to my chart (I can select all 4 to be active at the same time from Excel) but only the last value and category setting remains active (if the last value gridline was major, then it will be major, and if the last category gridline was minor, it will be minor) So I can't make all 4 active from VBA. Why?


ActiveChart.SetElement (msoElementPrimaryValueGridLinesMajor)
ActiveChart.SetElement (msoElementPrimaryCategoryGridLinesMajor)

ActiveChart.SetElement (msoElementPrimaryValueGridLinesMinor)
ActiveChart.SetElement (msoElementPrimaryCategoryGridLinesMinor)

b) There are some SetElement lines which show "Method 'SetElement Of Object Chart' failed".


ActiveChart.SetElement (msoElementLineDropHiLoLine)
ActiveChart.SetElement (msoElementChartWallNone)
ActiveChart.SetElement (msoElementLineSeriesLine)

c) And there is a chart element in excel called something like "Positive / negative differences"
but when I record that action, it only records this single line which is completely useless:

ActiveChart.SetElement (msoElementPlotAreaShow)

 

[Jamualson]

All of these has to be set by "ActiveChart.ChartGroups(1).Has..." properties, for example "HasMajorGridlines = True". Strange, but all of these problems are solved by this small change.