Sometimes developers like to take control of excel's look and feel and stop
users from doing stuff. And when things go wrong (or you just want to do
something the developer didn't think of), it won't work.
If you haven't customized your toolbars, you can reset them (all of them) by
deleting/renaming a file called *.xlb (name and location vary depending on
versions of windows and excel).
Use Windows|find (or Search) to look for *.xlb
(look for hidden files in hidden folders, too)
Rename all you find to *.xlbOld
(Only one is really used, but there could be some lingering out there depending
on your upgrade path.)
But you will have to rebuild any custom changes you've made to any of your
Option 2 (less drastic, but more work).
select worksheet menu bar and click reset
(You only lose the changes to that one toolbar)
Then for the right click menu problem:
alt-f11 (to get to the VBE where macros live)
ctrl-g (to see the immediate window)
heck you could do this one, too instead of the tools|customize stuff:
application.CommandBars("worksheet menu bar").reset
After you've done all this stuff (and added back your custom changes), close
excel and search for *.xlb once more.
Find the one you've just updated and copy it to a nice safe location.
Next time you have a problem with your toolbar, just close excel and copy this
saved version and paste into that folder containing the problem *.xlb file.