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

should do it.

-----Original Message-----
You could try:

Sub CancelF9()
Application.OnKey "{f9}", ""
End Sub
you will have to run the procedure for it to work - when
F9 pressed it should do nothing - but not tested.

Hope helpful.

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

.

.