Sub ResetF9()
Application.OnKey "{f9}", ""
End Sub

should do it.

-----Original Message-----

Thanks guys, works great.

Can I set a VBA macro to enable the F9 once that
particular procedure
has finished ?

Thanks again.

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

.