Hi,
I am trying to stop my users from hitting esc key while importing the text file through selection
Please Login or Register to view this content.
I wish that at this stage the escape key should be disabled & message them that esc key is disabled.
I have tried using Application.EnableCancelKey = xlDisabled but at the end it reaches to .Refresh BackgroundQuery:=False
( I have tried True also) but no luck.
Please any help.
Last edited by Leith Ross; 10-15-2011 at 07:46 PM. Reason: Added Code Tags
Hello foncesa,
You can reassign the escape key to another another macro temporarily using Application.OnKey
Here is an example:
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
You might want to consider that some users, when they find that the ESC key doesn't work, begin unplugging equipment.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I agree with Mike.
Entia non sunt multiplicanda sine necessitate
My tweaking tool of choice is a 3lb. sledge hammer. Always close at hand.
Hi,
Thanks for the reply but still unable to achive the results.
Please Login or Register to view this content.
It shows this error message.
& if debug is pressed it reachesPlease Login or Register to view this content.Please Login or Register to view this content.
Last edited by foncesa; 10-16-2011 at 10:19 AM.
Please change your QUOTE tags to CODE tags.
Did you translate the error message
into a language you understand ?Excel cannot find the text file to refresh this external date range.
Check to make sure the text file has not been moved or renamed, then try the refresh again.
Perhaps try Application.EnableCancelKey = xlDisabled
It deals with how VBA should handle whenever the user presses the ESC key when a macro is run. By default its xlInterrupt.
Private Sub Workbook()
Application.OnKey "{ESC}", ""
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks