Disable Cut/copy In Workbook

BruceMutton · Dec 14th 2005

In the Dec 2005 Ozgrid newsletter there is some sample code to disable commandbar controls.

The example code crashes when it trys to disable the copy button on the Clipboard menu (Excel 2000) and ONLY the clip board menu. All others are fine.

Code

'Disable all Copy menus
     For Each oCtrl In Application.CommandBars.FindControls(ID:=19)
            oCtrl.Enabled = False
     Next oCtrl

Any ideas why?

Anonymous · Apr 11th 2007

Re: Disable Cut/copy In Workbook

my911, That is the third attempt to hijack a thread. One more and I will stop you posting for a while! Please stop it and start your own threads!

Dave Hawley · Apr 12th 2007

Re: Disable Cut/copy In Workbook

The user has also emailed his question direct to me, breaking yet another of the rules he/she agreed to. I have disabled my911 posting ability and requested he read the rules and then let me know.

Disable Cut/copy In Workbook

Participate now!

Share