Popup Insert greyed out

[stephen]

Normally to insert a column I would select the entire column, and then
using the popup menu select insert....This would insert another column
adjacent to the highlighted column...

For some unknown reason the insert command on my popup menu is now
showing as grayed out..

Using the same method, but for a row instead of a column works OK

I have tried removing Excel totally and reinstalling, however the menu
still remains greyed out...

Any ideas would be appreciated

Thank you

Stephen

 

[Dave Peterson]

What version of excel are you running?

If you're running xl2002+, the worksheet could be protected (tools|Protection).
xl2002+ has options to allow insertion of rows and insertion of columns.

 

[stephen]

Hi Dave,

I'm running 2002, I had already checkd the workbook protection and
everything is fine.

 

[Dave Peterson]

Does it happen on every worksheet of every workbook or just some of the time?

If it happens on every worksheet in every workbook, then maybe just resetting
that column popup would be sufficient:

Open excel
hit alt-f11 (to get to the vbe)
hit ctrl-g (to see the immediate window)
type this and hit enter:
application.CommandBars("column").Reset

Then back to excel to test it out.

=====
You could also reset every toolbar that you've ever used.

if you want to try:

close excel
windows start button|search
look for *.xlb
and rename all you find to *.xlbOLD

restart excel and test it out

You'll have to rebuild any custom changes you've made.

===
If it doesn't work, just rename the *.xlbOLD back to *.xlb (you may have to
delete any new *.xlb before you rename the old)

 

[stephen]

Hi Dave..

Some success....by using the "application.CommandBars("column").Reset"
it looks like it has now ungreyed the Paste and Paste Special commends,
which I'm sure were also grayed previously

The Insert however is still grayed

Regarding *.xlb...I have searched my drive and can not find any
instances of this file ??....Could this be why i have the problem

Thank you
Stephen

 

[stephen]

Hi Dave.

Im not sure why my search didn't come up with *.xlb files, however i
checked MS web site and found this file should reside in the users
directory structure...Have checked this i have located EXCEL10 file,
which i reanmed as per your advise....

Hey Presto...I now have my Insert option back..Problem solved !

Thank you for your assistance and you have a great weekend !

Stephen

 

[Dave Peterson]

I didn't notice that the "Row" toolbar was broken, too.

You could have tried just resetting that one, too.

But if you deleted .xlbold, then that option is gone. Besides, it's always nice
to rebuild the toolbars with what you currently need.

In fact, once you rebuild that *.xlb file, make a backup of that file. Then if
something bad happens, you can just copy the back up into that folder (with
excel closed) and you'll be up and running really quickly.