你如何发送一个转义键击来excel vba
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/19301615/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
how do you send an escape key stroke to excel vba
提问by Behrooz Karjoo
After I cut and paste columns to a log worksheet the copy selection borders remain. Manually clicking escape gets rid of them. How can I get rid of them in the macro code? Escape key is not recorded by macro recorder.
在我将列剪切并粘贴到日志工作表后，副本选择边框仍然存在。手动点击转义可以摆脱它们。如何在宏代码中摆脱它们？宏记录器不记录退出键。
回答by Siddharth Rout
You don't need to send the Esckeystroke for this. Simply add this line after the paste command.
您不需要为此发送Esc击键。只需在粘贴命令后添加这一行。
Application.CutCopyMode = False
