preventing use of F9 (recalculate)
 

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

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

Many thanks for your help with this one.

Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=26273

preventing use of F9 (recalculate)
 

Hi
AFAIK this is not possible

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

.

preventing use of F9 (recalculate)
 

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

.

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

.

preventing use of F9 (recalculate)
 

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

.

.

preventing use of F9 (recalculate)
 

Don't forget to stop me from using:
Tools|options|calculation tab|and clicking that button.

And shift-F9, Ctrl-Alt-F9, and ctrl-shift-alt-f9, too.

And even just selecting a cell, hitting F2 and then enter to calculate that one
cell.

scottwilsonx wrote:

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...o&userid=11128
View this thread: http://www.excelforum.com/showthread...hreadid=262735

--

Dave Peterson