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:
Dim ComBar As CommandBar
Dim ComBarCtrl As CommandBarControl
Sub EnableAllClear() ' // Insert
Was this article helpful?