I am using Excel 2007 and I can not use the rigt mouse click in any spreadsheet - if I open up VB and put in
Sub Enable_All_Right_Click_Menus()
'This will enable all BuiltIn Command bars
Dim Cbar As CommandBar
For Each Cbar In Application.CommandBars
Cbar.Enabled = True
Next
End Sub<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Then hit F5 (or select run from the menu)
I can use the right click but when I close and open Excel again I have to create it again.
Any permanent fix anyone knows of?
Sub Enable_All_Right_Click_Menus()
'This will enable all BuiltIn Command bars
Dim Cbar As CommandBar
For Each Cbar In Application.CommandBars
Cbar.Enabled = True
Next
End Sub<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Then hit F5 (or select run from the menu)
I can use the right click but when I close and open Excel again I have to create it again.
Any permanent fix anyone knows of?