Tuesday, January 3, 2012

Excel 2007 no Right-Click Problem

Ever experience with no right click on sheets for Microsoft Office 2007?
do this :-

1. Open New Excel Document

2. Go to VB Editor by pressing ALT+F11 and double click on This Workbook ( top left )

3. Type in or Copy/Paste this command :

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

 
then press F5 to run macro
4. Press ALT+Q to quit VB Editor and the problem should gone

5. To keep the setting save the file to any name with Excel MACRO ( can be choosen from the File Type )

6. Now open another excel file and test..

No comments:

 Simple Python Calculator This script will allows your to calculate the integers given with the chosen operation. You can add, substract, mu...