Excel上的Ctrl + c 是正常的,但右鍵上的複製選項確反白了。無法使用,請看此文:

下面是解決方式:
請在excel 上,按 Alt + F8 (如果是筆電,請按 Alt + Fn + F8),輸入 RecoverExcel,再按 CREAT

copy below text and past it to VB\ Copy下面的代碼重置excel設置。
Dim i As Byte
On Error Resume Next
Application.ScreenUpdating = False
For i = 1 To 155
Application.CommandBars(i).Reset
Application.CommandBars(i).Enabled = True
Application.CommandBars(i).Visible = False
Next
Application.CommandBars("Status Bar").Visible = True
For i = 1 To 4
Application.CommandBars(i).Visible = True
Next
With Application
.OnKey "^c"
.OnKey "^v"
.OnKey "^x"
.OnKey "+{DEL}"
.OnKey "+{INSERT}"
.CellDragAndDrop = True
.OnDoubleClick = ""
End With
Application.ScreenUpdating = True
Past it in VB\ 貼上它, 如下圖

Hit play icon \再按PLAY icon 就可以了.

Done\完成.