Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rendering Numbers into Written Words | Excel Discussion (Misc queries) | |||
excel chart rendering problem when using apache java Poi package. | Excel Discussion (Misc queries) | |||
How to export a Chemdraw rendering from excel to word? | Excel Discussion (Misc queries) | |||
Excel - Rendering ASCII via ASP/JScript | Charts and Charting in Excel | |||
Can you stop charts from plotting logic statements as 0 | Charts and Charting in Excel |