Application.Onkey for ^F not working

  • Thread starter Thread starter Roopa
  • Start date Start date
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.
 
The workbook activate event will only occur in that workbook in which the
macro resides.
 
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
Deactivate / Reactivate the Paste Function in excel 1
application.onkey doesn't work within a cell 1
Disallow CTRL+ALT+DEL 8
Strange behaviour 4
OnKey for Alt f not overriding standard use of Alt-F 1
A negative to using Application.Onkey 6

Back
Top