티스토리 뷰



MS Office Word VBA를 이용하여 본문 복사 & 붙여넣기를 제한하는 방법



VBA 모듈


Sub CtrlC_Clear()


' Enable Ctrl + C & Ctrl + V


FindKey(BuildKeyCode(wdKeyControl, wdKeyC)).Clear

FindKey(BuildKeyCode(wdKeyControl, wdKeyV)).Clear


End Sub


Sub CtrlC_Disable()


' Disable Ctrl + C & Ctrl + V


FindKey(BuildKeyCode(wdKeyControl, wdKeyC)).Disable

FindKey(BuildKeyCode(wdKeyControl, wdKeyV)).Disable


End Sub

[참고사이트]

https://social.msdn.microsoft.com/Forums/en-US/260b1f92-abf8-4478-831b-446c1ceefe82/how-to-disable-copypaste-in-word-2003?forum=isvvba

 BuildKeyCode 方法http://www.cnxos.com/document/office/VBAWD10/html/womthBuildKeyCode.htm


Sub Disable_Right_Click()

Application.CommandBars.AdaptiveMenus = False

End Sub

 

Sub Enable_Right_Click()

Application.CommandBars.AdaptiveMenus = True

End Sub


http://vbadud.blogspot.kr/2007/04/disable-right-click.html

 


댓글
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
«   2024/05   »
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
글 보관함