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.

The workbook activate event will only occur in that workbook in which the
macro resides.
--
Gary''s Student - gsnu200820

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.

"Gary''s Student" wrote:

The workbook activate event will only occur in that workbook in which the
macro resides.
--
Gary''s Student - gsnu200820