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