Aptitude GPG Error Simple Solution

Always getting some gpg error while trying to do aptitude update on older version of debian platform such as etch or lenny. The message looks like this :

The following signatures couldn't be verified because the public key is not available: NO_PUBKEY AED4B06F473041FA

what should we do?
1st of all you have to be a root and check the key first with pgp.net server : the command is :
#gpg --keyserver wwwkeys.us.pgp.net --recv-keys AED4B06F473041FA

then it should return like this :

gpg: requesting key 473041FA from hkp server wwwkeys.us.pgp.net
gpg: key 473041FA: public key "Debian Archive Automatic Signing Key (6.0/squeeze " imported
gpg: no ultimately trusted keys found
gpg: Total number processed: 1
gpg: imported: 1 (RSA: 1)



what's next?


#gpg --armor --export | apt-key add -


then do aptitude update again and it should work

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..