MS Excel : Right mouse disabled?

when dealing with macro from any MS Access or Excel, i found that sometime it will disable right mouse click on sheet in MS Excel. I did not know what's going on but it really give me a headache. Searching around the google and found this solutions :-

Open Excel

Press ALT+F11 to open visual basic editor

Go to View -- Immediate Window and paste this command then press enter

Application.CommandBars("Cell").enabled = true

next try to right click on sheet.. it works for me..

another option :-

On Error Resume Next
Application.CommandBars(”Worksheet Menu Bar”).Enabled = True
Application.CommandBars(”Standard”).Enabled = True
Application.CommandBars(”Standard”).Enabled = True
Application.CommandBars(”Cell”).Enabled = True
Application.DisplayFormulaBar = True
Application.DisplayStatusBar = True
Application.CommandBars(”Toolbar List”).Enabled = True
Application.DisplayFormulaBar = True
ActiveWindow.DisplayHeadings = True
Application.DisplayStatusBar = True
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.DisplayVerticalScrollBar = True
ActiveWindow.DisplayWorkbookTabs = True
Application.CommandBars(”Standard”).Visible = True
Application.CommandBars(”Formatting”).Enabled = True
Application.CommandBars(”Formatting”).Visible = True
Application.CommandBars(”Chart”).Enabled = True
Application.CommandBars(”Forms”).Enabled = True
Application.CommandBars(”Web”).Enabled = True
Application.CommandBars(”Reviewing”).Enabled = True
Application.CommandBars(”Visual Basic”).Enabled = True
Application.CommandBars(”Drawing”).Enabled = True
Application.CommandBars(”web”).Enabled = True
Application.CommandBars(”Picture”).Enabled = True
Application.CommandBars(”PivotTable”).Enabled = True
Application.CommandBars(”CELL”).Enabled = True
Application.CommandBars(”Visual Basic”).Enabled = True