Applocker Forgot Password

If you forget the password, you can connect iPhone to iFunbox, then find its configuration files in the iPhone.
This patch:
/var/mobile/Library/Preferences/com.nnfyrbsnss.applocker.plist
<?xml version=”1.0″ encoding=”UTF-8″?>
<!DOCTYPE plist PUBLIC “-//Apple//DTD PLIST 1.0//EN” “http://www.apple.com/DTDs/PropertyList-1.0.dtd”>
<plist version=”1.0″>
<dict>
<key>Appslibactivator</key>
<true/>
<key>applockerpassword</key>
<string>111</string>
<key>behavior</key>
<true/>
<key>enabled</key>
<true/>
</dict>
</plist>
Here behaviorkey is enabled, which indicates that the tweak is in the enabled state, applockerpassword is the password you set (above the 111 as a password). Here you can change the password, or delete this file, to back to the unlocked state.

OFFICE 2010 HOME&STUDENT KEY

P823K-XBK37-2869K-KRWYQ-F4CBX

Download Quran

http://quran.ksu.edu.sa/ayat/?l=en
 

Fix and Restore Windows 7 Boot Screen That Changes to Vista Style

 

Sometimes, the beautiful, elegant, high resolution animated and dynamic Windows 7 boot screen UI may be changed to or replaced with Windows Vista boot screen, normally when user adds a Windows 7 entry in boot menu or accidentally when user attempts to repair the startup menu items with Windows Vista DVD, specifically Startup Repair. Windows Vista boot screen is a boring black background with low resolution green running progress bar.

The invalid and wrong boot screen for Windows 7 is due to missing locale entry in boot record, which failed to be set when editing or rebuilding the BCD. When locale is not found, Windows boot loader does not know which boot locale folder to look for the animated bootscreen. Thus, in order to fix the boot screen so that the boot screen can be reverted, restored or reseted back to original animated Windows 7 boot screen, just run one of the following commands in elevated command prompt with administrator rights:

bcdedit /set {current} locale en-US

or 

bcdboot %WinDir% /l en-US

Change the en-US to the language version of the installed Windows 7, such as ja-JP, de-DE, es-ES, pt-BR, zh-CN, zh-TW, fr-FR, fi-FI and etc.

Restart the computer after running the command to see the new boot UI (user interface) be used again. To check if the locale setting has been entered properly, just run the bceedit command in command prompt that runs as administrator.

Excel Formulae

Excel Formulae 

Remove zeros from Excel 

0;-0;;@ 

Convert Date to month: 

=DATE(YEAR(A2),MONTH(A2),1) 

Find Job Location: 

=IF((D2="VACATION"),IF(F2<>"VACATION",F2,IF(H2<>"VACATION",H2,J2)),IF(D2="",F2,D2))

Roundup date to Next month: 

=IF(AND(DAY(A2)>=1,DAY(A2)<25),DATE(YEAR(A2),MONTH(A2),1),DATE(YEAR(A2),MONTH(A2)+1,1)) 

where A2=Date to be rounded up to next month 

Number 25 could be changed to the desired roundup days

 

Find if Duplicates: 

=countif(a:a,a2)>1 

Count number of Duplicates occurances(index): 

=countif(a$2$:a2,a2) 

Count Duplicates: 

=countif(a:a,a2) 

Show the last saved date: 

VBA Code 

Sub getChangeInfo() 

Dim lastAuth, lastSave 

lastSave = ActiveWorkbook.BuiltinDocumentProperties(12) 

ActiveSheet.Range("A1") = "Last Saved: " & lastSave 

End Sub 

Save sheets sepertely from Excel Book: 

VBA Code 

Sub CreateWorkbooks() 

Dim wbDest As Workbook 

Dim wbSource As Workbook 

Dim sht As Object 

Dim strSavePath As String 

On Error GoTo ErrorHandler 

Application.ScreenUpdating = False 

strSavePath = "C:\Temp\" 

Set wbSource = ActiveWorkbook 

For Each sht In wbSource.Sheets 

sht.Copy 

Set wbDest = ActiveWorkbook 

wbDest.SaveAs strSavePath & sht.Name 

wbDest.Close 

Next 

Application.ScreenUpdating = True 

Exit Sub 

ErrorHandler: 

MsgBox "An error has occurred. Error number=" & Err.Number & ". Error description=" & Err.Description & "." 

End Sub 

Upgrade WIndows 7 Basic to Ultimate

Anytime upgrade:
Enter key: FJGCP-4DFJD-GJY49-VJBQ7-HYRR2