CANNOT DELETE AN ENTIRE COLUMN

  • Thread starter Thread starter ibeetb
  • Start date Start date
I

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
 
Just a guess....

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

You will lose any customized changes to that toolbar, though.
 
Didn't work. But thanks anyway
Dave Peterson said:
Just a guess....

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

You will lose any customized changes to that toolbar, though.
Click to expand...
 
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

ibeetb said:
Didn't work. But thanks anyway
Click to expand...
 
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
Click to expand...
 
Back
Top