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
.