Superb! It worked...thanks.
--
Ed


"Jim Rech" wrote:

Ed-

Try running this macro. It will enable all "Delete..." menu items and tool
buttons.

Sub a()
Dim Ctrls As CommandBarControls
Dim Ctrl As CommandBarControl
Set Ctrls = CommandBars.FindControls(, 478)
If Not Ctrls Is Nothing Then
For Each Ctrl In Ctrls
Ctrl.Enabled = True
Next
End If
End Sub


--
Jim
"Ed White" wrote in message
...
| Indeed, if I rename the XLB file, the File-Delete... option becomes
available
| when I restart Excel. However, I have spent considerable time customizing
my
| icons, and I don't want to start over again, so how do I reactivate the
| File-Delete... command? I've checked all the macros in my Personal.XLS
file,
| and I don't see any of them disabling any commands.
| --
| Ed
|
|
| "Jim Rech" wrote:
|
| If you run a macro that disables any menu command that setting could
have
| been saved in your custom toolbar file. You might check this by
renaming
| your XLB file (with Excel closed) as that Excel does not reload it and
you
| get default menus and toolbars. It's typically found at:
|
| C:\Documents and Settings\<user name\Application Data\Microsoft\Excel
|
| --
| Jim
| "Ed White" wrote in message
| ...
| | All of the sudden, when I pull up any workbook in Excel (new or
previously
| | created), when I click Edit-Delete..., the Delete... is grayed out so
that
| I
| | cannot select it. Further, I have for icons across the top of Excel
for
| | deleting and inserting rows and columns. The icons to insert and
delete
| rows
| | work, and the icon to insert a column works, but the icon to delete a
| column
| | is grayed out (i.e. nothing happens when you click on it.) All of
this
| | worked before. What the heck could have changed this?
| | --
| | Ed
|
|
|