Adding Date and Time Last Modified to footer of an Excel worksheet

Here is a quick way to add Date and Time Modified (i.e. Last Saved) to your excel sheet to make sure no replication conflict exist or track latest updated version:
Please note (this is not a Data() function)

I. Particular Worksheet
a. Minimize inner window (i.e. spreadsheet you are working on) within the main Excel window.
b. You should not see the Excel Icon on the top of the worksheet (next to the title)
c. Right Click -> Select "View Code"
d. Past this code in the window that opened up

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = "Last saved: " & Format(Date, "dd-mm-yy") & " " & Time
End Sub

d. Click on ALT + Q to close window.
f. See date Last Saved in the footer in the print view after you save the file

II. Entire Workbook - applied across all worksheets in the document
a-c. Same as above
d. In the left top menu select ThisWorkBook
e. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
For Each Sheet In ThisWorkbook.Sheets
Sheet.PageSetup.LeftFooter = "Last saved: " & Format(Date, "dd-mm-yy") & " " & Time
Next Sheet
End Sub
f. Click ALT+Q to close window

Turn Microsoft Office 2007 Ribbon Menu to Office 2003 Classic Menyu

Here is a free solution to turning back time and returning to classic menu style so drasticaly changed in MS Office 2007 - UbitMenu. Download UbitMenu at ubitmenu.com

Mozilla Firefox Free Secuirty Add-on for search engine

Here is a new nifty free add-on I read about in PcWorld Magazine - Search Engine Security.
This add on protects you form attacks that originate as a result of a phony search engine results that infect you PC with malware. By default it works on Bing, Yahoo and Google.
I highly recommend this free add-on.

HDA AUDIO BUS DRIVER error message

Are you getting this error missing "HDA AUDIO BUS DRIVER is not INSTALLED" while installing you SoundMax driver on your Lenovo machine. Here is the solution. Download and install the driver:

ftp://ftp.hp.com/pub/softpaq/sp33501-34000/sp33867.exe

Enjoy!

Access Adobe Flash Player Settings Manager

Follow the link below to open a new internet explorer window containing a box on the right hand side titled 'Adobe Flash Player Settings Manager'. 

Access Flash player Settings

How to remove and clean malware - Security Suite Malware Virus Removal Guide for any Windows

So, your computer is infected with a malware called Security Suite which makes you believe it is an Anti-Virus software that just identified virus on your computer and offers you to remove it for a fee. This is a classic scam example. Security Suite is the virus which takes over your computer and does not let you uninstall/install any programs. It is super annoying and frustrating. So, here are number of effective solutions for you to remove Security Suite without paying a penny. DO NOT PAY!

I.  Most Simple and quick good old way (works about 50% of times)

Sometimes Security Suite appears as harmless to anti viruses and cleaners because it does not infect any files. So, this is the most straight forward way and STEP 1 for Security Suite virus removal.

1. Go to C:\Users\YourUserName\AppData\Local
2. Sort Files by DATE MODIFIED and delete all suspicious files.

Note if you can't access the folder because Security Suite is blocking it access it via SAFE MODE (see below for instructions on how to ran your machine in SAFE MODE)

II.  Using you Computer SYSTEM RESTORE TOOL(works about 60% of times)

1. Shut Down you computer
2. Run your computer in SAFE MODE
• Press F8 key as you computer is starting up
• A start-up option window will appear
• Select SAFE MODE
3.  Once in SAFE MODE run SYSTEM RESTORE (note you will not loose any data)
• Start
• Program
• Accessories
• System tools
4. RESTORE your computer to the earlier date (approximate date before the virus started)

III. Complete and thorough malware and virus removal (this will take 1-3 hours but works 95% of times)

1. Reboot Your PC -> When it starts (but BEFORE you see windows loading) start hitting F8.
2. This will put Windows in Safe mode and will prevent the Security Suite from loading. Make sure to choose Safe Mode - Start Windows with Networking
3. Now download and install the following free applications  (Google them)
 - Malwarebytes (Google it).
 - CCleaner
 - Spyware Terminator.
4. Install all software
5. First run CCleaner. Make sure you tick the boxes to delete temporary internet files.
6. When CClener it's done, run Malwarebytes. When ti's finished, delete what it found.
7. Now run Spyware Terminator.
Then run your antivirus. If you need one, Avast and/or AVG are decent free alternatives. It's free. Once your AV runs, delete anything it finds.
8. Once you are clean and now protected go an extra step and install firewall.
I use ZoneAlarm (free edition)