[belajar-excel] MENONAKTIFKAN FUNGSI CUT (CTRL+X)

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] MENONAKTIFKAN FUNGSI CUT (CTRL+X)

It Dpm
Dear para master Excel...
mohon bantuan bagaimana caranya menonaktifkan fungsi CUT (Ctrl+X) hanya pada file excel tertentu, tetapi untuk Copy masih diperbolehkan.

terima kasih.
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] MENONAKTIFKAN FUNGSI CUT (CTRL+X)

Agus-2
Dear It Dpm,
Tidak bisa!
selama macro dinonaktifkan.
Jika macro aktif dapat digunakan cekrip:

Option Explicit
Private Sub Workbook_Activate()
Application.OnKey "^{x}", ""
End Sub

Private Sub Workbook_Deactivate()
Application.OnKey "^{x}"
End Sub

Private Sub Workbook_Open()
Application.OnKey "^{x}", ""
End Sub

Regard
NangAgus

On 7/15/2019 11:19, It Dpm [hidden email] [belajar-excel] wrote:
> Dear para master Excel...
>
> mohon bantuan bagaimana caranya menonaktifkan fungsi CUT (Ctrl+X)
> hanya pada file excel tertentu, tetapi untuk Copy masih diperbolehkan.
>
>
> terima kasih.
>



Turn Off Ctrl X.xlsm (19K) Download Attachment