Stop Charts from Rendering

  • Thread starter Thread starter PJFry
  • Start date Start date
P

PJFry

I am running Excel 2007 on a worksheet with about 450,000 data points. Every
now and then I accidently hit F11 and Excel tries to chart the worksheet. Is
there anyway to stop the chart from rendering once it has started? I usually
loose about five mintues waiting for Excel to either finish or tell me it
won't work. The load has crashed Excel every now and then.
 
Hi,

I don't think you can breakout once the action has started.

Maybe you could use some code to stop the accidents.

this routine,

'--------------------------
Sub ConfirmChart()
If MsgBox("Are you sure you want to create a chart", vbYesNo Or
vbQuestion) = vbYes Then
Charts.Add
End If
End Sub
'--------------------------

And this command to assign F11 to the macro

application.OnKey "{F11}","ConfirmChart"

Cheers
Andy
 
That is a great idea. Thanks!
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.
 
Back
Top