preventing use of F9 (recalculate)
 

Thanks guys, works great.

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

Thanks again.

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)
 

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

.

preventing use of F9 (recalculate)
 

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

.

preventing use of F9 (recalculate)
 

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

.



.