CANNOT DELETE AN ENTIRE COLUMN
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.
ibeetb wrote:
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" wrote in message
...
Didn't work. But thanks anyway
"Dave Peterson" wrote in message
...
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 wrote:
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
--
Dave Peterson
|