7 Dec 2011

Unprotect Excel sheet

Open protected sheet, right click an select View Code or press a short cut Atl+F11.
Copy and paste the below code and Run.
Enjoy :-)

Sub PasswordBreaker()
Dim i As IntegerAs IntegerAs Integer
Dim l 
As IntegerAs IntegerAs Integer
Dim i1 
As Integeri2 As Integeri3 As Integer
Dim i4 
As Integeri5 As Integeri6 As Integer
On Error Resume Next
For 65 To 66: For 65 To 66:         For 65 To 66
 
For 65 To 66: For 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 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

         ActiveWorkbook
.Sheets(1).Select
         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 NextNextNextNextNextNext
Next
NextNextNextNextNext

End Sub 

6 Dec 2011

DPMRA can not start with error 1168

Verify you COM+ rights for the DPM agent. It could be that there is a missmatch in the rights.
Click START / Administrative Tools / Component Services
Expand Component Services / Computers / My Computer / DCOM Config
Right click on the "DPM RA Services" and choose properties. Verify that under the Security tab / Launch and Activation Permissions you got Customize marked, click the Edit... button in the ACL you should see the computer account for your DPM server. If it's not present add it and mark all allow boxes and try to start the service again.

Total Pageviews