Application.Onkey for ^F not working

R

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.
 
G

Gary''s Student

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reset the macro assigned to Ctrl+F on workbook deactivate 11
Conditional application.onkey in realtime? 2
OnKey for Alt f not overriding standard use of Alt-F 1
Application.OnKey Macro Cannot be found 3
A negative to using Application.Onkey 6
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Strange behaviour 4
Assign different keyboard shortcuts 4

Top