Quite right Tom, thanks for correction.
-----Original Message-----
Since that is the exact code that you provided to
disabled it, I suspect you
meant

Sub RestoreF9()
Application.OnKey "{f9}"
End Sub

--
Regards,
Tom Ogilvy


"dude" wrote in
message
...
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

.



.