Weird scenario leading to ResetColors crash
Hi All
If I reference Shapes on a chart sheet, then switch to a normal Worksheet
and Reset the default palette - Excel crashes, both XL97 and XL2000.
However no problem later to reset the palette if the same Chart sheet is
still active. Also, if I check the shapes on a chart object on a worksheet,
I can reset default palette while any type of sheet is active.
It's taken a very long time to track what appeared to be intermittent
crashes to these two innocuous lines, dispersed in a large project.
Not sure if anyone else will reproduce the same GPF, but is these some other
way I can reference shapes on a chart sheet and later be able to reset
palette on a normal worksheet.
Sub ChtShapes()
Dim n As Long, ob As Object
'run on a chart sheet
n = ActiveChart.Shapes.Count
'or
'Set ob = ActiveChart.Shapes
End Sub
Sub ColorsReset()
' **** posible crash - ensure no work loaded
'switch to a normal worksheet
ActiveWorkbook.ResetColors
End Sub
Thanks in advance,
Peter T
|