whoops:
forgot to add empty proceedure call - otherwise key
reverts to normal use.

Sub CancelF9()
Application.OnKey "{f9}", "donothing"
End Sub

Sub donothing()
End Sub

hope helps

-----Original Message-----

Hello. Is there a way to automatically stop someone from
being able to
press F9 to recalculate the formulae in a spreadsheet ?

The reason I need to prevent this keystroke is that I am
running a
separate sort macro and when the F9 is pressed after the
sort it
automatically reorders the number based on a number of
INDEX formulas.

Many thanks for your help with this one.

Scott.


--
scottwilsonx
----------------------------------------------------------
--------------
scottwilsonx's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=11128
View this thread:
http://www.excelforum.com/showthread...hreadid=262735

.