Excel表格右键失灵解决办法
1.首先打开excel文档点击顶部菜单栏中的文件选项在弹出的选项列表中，点击选项切换到视图栏目下勾选【右键时显示浮动工具栏】选项2.打开Excel按alt+f11点击运行->运行宏创建一个宏并命名，命名自定义即可复制并粘贴下列代码Dim i As ByteOn Error Resume NextApplication.ScreenUpdating = FalseFor i = 1 To 155Application.CommandBars(i).ResetApplication.CommandBars(i).Enabled = TrueApplication.CommandBars(i).Visible = FalseNextApplication.CommandBars("Status Bar").Visible = TrueFor i = 1 To 4Application.CommandBars(i).Visible = TrueNextWith Application.OnKey "^c".OnKey "^v".OnKey "^x".OnKey "+{DEL}".OnKey "+{INSERT}".CellDragAndDrop = True.OnDoubleClick = ""End WithApplication.ScreenUpdating = TrueMsgBox "大功告成！" & "你的Excel已恢复。" & Chr(10) & "所有自定义菜单、按钮及功能限制均已解除。", 64, "【友情提示】"运行后查看是否解决WPS运行宏需要点击上方工具栏打开运行宏其它步骤和上述相同
页:
[1]