Application.Onkey for ^F not working

[Roopa]

Hi,
I have given a macro for Application.Onkey ^F in Workbook Activate event and
reset it in the workbook Deactivate event. Its working fine in my workbook
but in other excel workbooks when I did ^F nothing happening.
I couldnt findout the reason why its not working in other excels.
Can anyone help me out here.
Thanks.

 

[Gary''s Student]

The workbook activate event will only occur in that workbook in which the
macro resides.

 

[Roopa]

Hi Gary,
Thanks for the reply.
I think I am not clear in my question sorry about that.
Macro doesnt work in other excels but if i give
Application.Onkey "^f"
then it should reset to its normal functionality so that normal ^F works on
other excels. But eventhough i reset to normal functionality, dialog box
itself not being displayed in other excels.