Posted to microsoft.public.excel.programming

iperlovsky iperlovsky is offline

external usenet poster

Posts: 50

Disable Command Bar Edit Control

I am attempting to use this sub routine to disable the cut control under the
Edit menu and all the sub menus, but the menu is still allowing me to cut. I
have Excel 2003. Any help is appreciated.

Sub MenuControl_False()
Dim Ctrl As Office.CommandBarControl
For Each Ctrl In Application.CommandBars.FindControls(ID:=21)
Ctrl.Enabled = False
Next Ctrl
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy command is disable under edit menu	Anirban Dutta	Excel Discussion (Misc queries)	2	March 22nd 07 10:56 AM
Disable the Delete Control in the Edit Menu	Virtual Hillbilly	Excel Programming	1	July 23rd 06 10:50 AM
Disable Edit Fill	TEAM[_8_]	Excel Programming	5	December 16th 05 09:42 PM
Disable Edit Query	Peter Sze[_2_]	Excel Programming	3	September 22nd 04 09:18 AM
Disable the Edit menu command 'Paste Special'	George Raymond	Excel Programming	4	December 22nd 03 04:44 AM

All times are GMT +1. The time now is 10:04 AM.

About Us

"It's about Microsoft Excel"