Disable Cut Copy and Paste

Submitted by Ivan F. Moala.

There are times when you do not want your clients to interfere with the structure of a worksheet. This program disables/enables all methods of cutting, copying, and pasting data in Excel:

Option Private Module

Dim ComBar As CommandBar

Dim ComBarCtrl As CommandBarControl

Sub EnableAllClear() ' // Insert

EnableControl 295, True '// ..cells EnableControl 296, True '// ..Rows EnableControl 297, True '// ..Cols '// &Delete...

Was this article helpful?

0 0


Post a comment