Friday, January 21, 2011

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

Thursday, January 13, 2011

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.