Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recalculate in VBA | Excel Discussion (Misc queries) | |||
formulas won't recalculate | Excel Worksheet Functions | |||
Recalculate changes only | Excel Discussion (Misc queries) | |||
Won't recalculate | Excel Discussion (Misc queries) | |||
will not recalculate | Excel Worksheet Functions |