Wednesday, 5 March 2014

Right click doesn't work in Excel 2007.

Problem:

When you right click on excel spreadsheet it do not show anything.

Solution:

1. Open excel 
2. Hit alt-f11 to get to the VBE 

3. Hit 
ctrl-g to see the immediate window 

4. Type this and hit enter: 

      application.CommandBars("Cell").Reset      application.CommandBars("cell").Enabled = True
5. Hit alt-f11 to get back to excel and test it out.