Thursday, March 12, 2009

article logoBroke any password in Excel

Break Excel sheet Protection
When you are facing any excel sheets are protected with password or you protect that sheet with password long time ago and you forgot that password, then you can use these below code to break the password. Just Right click on sheet tab and click View Code. Microsoft Visual basic editor will open. Paste these code and Click Run. A popup window will come with your password. That's it.

'Author unknown
'Dim i As Integer, j As Integer, k As Integer
'Dim l As Integer, m As Integer, n As Integer
'Dim i1 As Integer, i2 As Integer, i3 As Integer
'Dim i4 As Integer, i5 As Integer, i6 As Integer
'On Error Resume Next
'For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
'For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
'For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
'For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126

'ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
'Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
'Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
'If ActiveSheet.ProtectContents = False Then
'MsgBox "One usable password is " & Chr(i) & Chr(j) & _
'Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
'Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
'Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _
'Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
'Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
'Exit Sub
'End If
'Next: Next: Next: Next: Next: Next
'Next: Next: Next: Next: Next: Next
'End Sub

article logoChanging your System Propreties Logo with your own!

The Windows XP System Properties logo is often changed by computer manufacturers. Hardware vendors use this general system information dialog to brand your computer with their own logo and support contact information.
In this tip you can learn how you can insert your own logo in the system properties dialog and complete it with your own contact information. To invoke the system properties dialog, click the Start button, right-click "My Computer" and select "Properties". This will open up your general system information dialog. On our Fujitsu-Siemens Amilo Pro laptop, the Windows XP System Properties logo looks like this -
If you want to put your own graphic in there, you should create your image in a .bmp graphic file. It's also a good idea to create this bitmap image with the same background shade of gray (RGB: 192, 192, 192) used in the Properties dialog. Otherwise, you risk letting Windows make its own judgments regarding color contrast and background shading.

The next thing to consider is the image size. The system properties dialog only offers enough real estate for an image of about 180 (wide) x120 (high) pixels. Make sure that you can fit your logo in this area.

Once you have created your logo and saved it as a .bmp file, copy it over to the system32 subfolder of your Windows system folder. If you don't know where your system folder is :

  • Click the Start button and select "Run" (without the quotes)
  • In the "open" field, enter "cmd" (without the quotes) and click OK
  • Windows will open up a dos command window
  • In the command window, type "set system" (without the quotes)
  • Look for the line that contains "SystemRoot", this is where your system directory is (generally, the Windows XP system folder is c:\windows)

Now that you know where your system folder is, copy your logo image file over to the system32 subfolder of your system folder. Then rename your logo image file to oemlogo.bmp

Additionally you can create a new file in this same folder and name the new file oeminfo.ini

In this file you can enter your contact information like in the example below :

Manufacturer=Alpona Graphics


[Support Information]
Line1=" "
Line2=" For support, sales, upgrades or questions:"
Line4=" (c) Copy Right the Windows & Logo by :-"
Line5=" Ziaur Rahman "
Line6=" Alpona Graphics"
Line8=" +88 01712071751"
Line9=" +88 01714867615"

Save and close the file and you are ready. From now on, if someone opens up the system properties dialog, your own Windows XP System Properties logo is in there.

And if someone clicks the "Support Information" button :