Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't delete columns
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't delete columns
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't delete columns
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't delete columns
Excuse me, I meant Edit-Delete..., not File-Delete...
-- 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't delete columns
Hi
Firstly, I think you may try to open the Excel application which will open a Book1.xls. In this point, was the menu enabled? Also you may try to run the macro below to enable the delete button. Sub Test() Dim o As CommandBarButton Set o = Application.CommandBars("Worksheet Menu Bar").Controls("Edit").Controls("Delete...") o.Enabled = True End Sub But I am not sure why the button will be disable, I am not sure if the code above will take effect. If so, I think you have to delete the xlb and reset the toolbar setting. Best regards, Peter Huang Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "AS IS" with no warranties, and confers no rights. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't delete columns
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 | | | |
#7
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 | | | |
Reply |
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 |