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..
Windows and linux information and one stop centre for myself. Having difficulties to remember all things at once. This blog will remain be my references on the internet. Other people can take benefit from it. Thank you for visiting
Subscribe to:
Post Comments (Atom)
Simple Python Calculator This script will allows your to calculate the integers given with the chosen operation. You can add, substract, mu...
-
when trying to apt-get update i got this error message :- W: There is no public key available for the following key IDs xxxxxxxxxxxx t...
-
Skrip ini aku guna kat server aku.. backup mysql setiap hari. Hanya perlu ubah pada bahagian setting sahaja. chmod dan set cron untuk daily ...
-
This tutorial will help you get AWStats and Lighttpd working together. AWStats is an excellent log analyzer, and works well with Lighttpd. T...
No comments:
Post a Comment