Stop Charts from Rendering
 

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.
--
Regards,

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

Stop Charts from Rendering
 

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
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"PJFry" wrote in message
...
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.
--
Regards,

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

Stop Charts from Rendering
 

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

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



"Andy Pope" wrote:

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
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"PJFry" wrote in message
...
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.
--
Regards,

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