preventing use of F9 (recalculate)

[scottwilsonx]

Thanks guys, works great.

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

Thanks again.

Scott

 

[dude]

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

should do it.

 

[Tom Ogilvy]

Since that is the exact code that you provided to disabled it, I suspect you
meant

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

 

[dude]

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





.