View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
dude dude is offline
external usenet poster
 
Posts: 12
Default preventing use of F9 (recalculate)

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

.