View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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