Please ignore my "Argument not optional" response. Adding the file name to
the OnKey statement fixes that.

e.g.

Application.OnKey "^%{F9}", "'ThisWorkbook.xls'!FullCalc"

Thanks,
Shawn

"Charles Williams" wrote:

Dont know why: but why dont you trap ctrl-alt-f9 with a VBA OnKey statement
and redirect it to a VBA Application.CalculateFull?

Application.OnKey "^%{F9}", "FullCalc"

Sub FullCalc()
application.calculatefull
end sub

Charles