crash on VBA - only on some laptops, never on PC - no messages, just shut down excel!

[david killoran]

I have a workbook with VBA code, that works brilliant on four different PC's.
But on two laptops, it shuts down excel without any warning messages, when executing a vba code.
I have changed the vba code and fixed the issue, but then it crashes on another bit of code.
but it never crashes on PC's or my own laptop. All excel 2016 windows 10.
Is it to do with add-ons, or memory or processor speed?
how can I fix this?

many thanks for any suggestions.

[david killoran]

Solved - I have found that when modifying any element of a chart, unless I actually selected the chart at least once initially, then on some PC's (and only some) it would crash and shut down excel.
Even if the PCs all use windows 10 and excel 2016 - With no com add-ins.

The problem code is as follows
[code]
Sub chart_run_OD()
Dim runcht As Chart
Set runcht = Sheets("run chart").ChartObjects("Chart_run").Chart
runcht.ChartTitle.Text = "OD" 'this is the crash point on some PC's and not always - only around 1/5 times when the code is run!
'extra code here
end sub
[code/]

here is the code that fixed the problem
[code]
Sub chart_run_OD()
Dim runcht As Chart
Set runcht = Sheets("run chart").ChartObjects("Chart_run").Chart
ActiveSheet.ChartObjects("Chart_run").Select
runcht.ChartTitle.Text = "OD"
'extra code here
end sub