F11 is going to try to build a chart for you.
If you have a giant selection--or a single cell in a giant used worksheet, it
can take quite awhile to build that chart.
Maybe you can kill F11 with a macro in your personal.xls workbook:
Option Explicit
Sub disableF11()
Application.OnKey "{f11}", ""
End Sub
This would toggle it back to normal.
Sub enableF11()
Application.OnKey "{f11}"
End Sub
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
kirkm wrote:
In the spreadsheet I'm developing the F11 key is causing concern,
especially if pressed. (Or, when someone presses it...!)
You either get (after Excel struggles a bit) -
Excel cannot complete this task with available resources. Choose less
data or close other applications.
Or the much worse -
Microsoft Excel has encountered a problem and needs to
close. We are sorry for the inconvenience.
This happens on every computer (tested = 4), not just mine.
I've no idea what F11 is meant to do - but can it be disabled?
Thanks - Kirk
--
Dave Peterson