Is it broken only in one workbook?
Is it broken in all the worksheets in that workbook?
If it's all worksheets in all workbooks:
Hit alt-f11 (to see the VBE--where macros live)
hit ctrl-G (to see the immediate window)
type this and hit enter:
application.commandbars("cell").enabled = true
then back to excel to test it.
If it still fails (back to the immediate window) and:
application.commandbars("cell").reset
Back to excel to test.
If it's still broken:
close excel
Use windows|find to find *.xlb (search in hidden folders for hidden files, too).
Rename it/them to *.xlbOLD.
Restart excel and try it out.
If it worked, then delete those *.xlbOLD files.
if it didn't work, then rename them to *.xlb.
*.xlb is where excel stores customized changes to the toolbar. It sounds like
yours got hosed (technical term).
If you end up deleting your *.xlb, then you'll have to do your customizations
again.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
