CANNOT DELETE AN ENTIRE COLUMN

[ibeetb]

All of a sudden, out of nowhere, I cannot delete and entire column in Excel.
Can someone offer suggestions to fix? When I highlight , for example, column
B, and go to Edit--Delte, the Delte is grayed out. Same when I right click.
the delete is grayed. This didn't happen yesterday but is happening today -
and this is with ANY worksheet whther populated or blank and they are NOT
protected

Thanks

Thank you

 

[Dave Peterson]

Just a guess....

Tools|Customize|toolbars tab
select worksheet menu bar
and click Reset

You will lose any customized changes to that toolbar, though.

 

[ibeetb]

Didn't work. But thanks anyway

Just a guess....

Tools|Customize|toolbars tab
select worksheet menu bar
and click Reset

You will lose any customized changes to that toolbar, though.

 

[ibeetb]

But by the way, I found a way to take your advice and put it in code and
THEN it did work!

'Used this when my Edit--Delete was disabled
Sub ResetCommnadBars()
For i = 1 To Application.CommandBars.Count
Application.CommandBars(i).Reset
Next
End Sub

Didn't work. But thanks anyway

 

[Dave Peterson]

If you're going to reset all your command bars, you can:

Close excel
use windows explorer and search for *.xlb
(search through hidden folders, too)
delete as many as you find (only one is really used, though)

All your existing customization will need to be redone.

But by the way, I found a way to take your advice and put it in code and
THEN it did work!

'Used this when my Edit--Delete was disabled
Sub ResetCommnadBars()
For i = 1 To Application.CommandBars.Count
Application.CommandBars(i).Reset
Next
End Sub