| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't delete columns
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 | | | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
| Can't delete columns | Excel Discussion (Misc queries) | |||
| I can't delete columns - help! | Excel Worksheet Functions | |||
| Delete columns | Excel Programming | |||
| Delete columns | Excel Programming | |||
Threaded Mode
