M mengxi Dec 3, 2003 #1 Please help. when i right click my mouse in excel workbook, no menu pops up! Please help!
D Dave Peterson Dec 4, 2003 #2 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.
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.
