windows 7破解-excel如何破解工作表密碼
7\工具—宏—–宏,選AllInternalPasswords,運(yùn)行,確定兩,等2鐘,再確定。
- windows 7破解,excel如何破解工作表密碼?
- win10和win?
- windows7激活期限已過怎么辦?
- windows7激活期限已過怎么解決?
- wincc運(yùn)行系統(tǒng)許可證如何破解?
windows 7破解,excel如何破解工作表密碼?
EXCEL工作表保護(hù)密碼破解
:
1打文件
2工具—宏—-錄制新宏—輸入名字:aa
3停止錄制(空宏)
4工具—宏—-宏,選aa,點(diǎn)編輯按鈕
5刪除窗口所字符(幾),替換面內(nèi)容:(**吧)
6關(guān)閉編輯窗口
7工具—宏—–宏,選AllInternalPasswords,運(yùn)行,確定兩,等2鐘,再確定。
OK,沒密碼!!
內(nèi)容:
Public Sub AllInternalPasswords()
‘ Breaks worksheet and workbook structure passwords。
Bob McCormick
‘ probably originator of base code algorithm modified for coverage
‘ of workbook structure / windows passwords and for multiple passwords
‘
‘ Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1。
1)
‘ Modified 2003-Apr-04 by JEM: All msgs to constants, and
‘ eliminate one Exit Sub (Version 1。1。
1)
‘ Reveals hashed passwords NOT original passwords
Const DBLSPACE As String = vbNewLine & vbNewLine
Const AUTHORS As String = DBLSPACE & vbNewLine & _
“Adapted from Bob McCormick base code by” & _
“Norman Harker and JE McGimpsey”
Const HEADER As String = “AllInternalPasswords User Message”
Const VERSION As String = DBLSPACE & “Version 1。
1。1 2003-Apr-04″
Const REPBACK As String = DBLSPACE & “Please report failure ” & _
“to the microsoft。
public。excel。programming newsgroup。”
Const ALLCLEAR As String = DBLSPACE & “The workbook should ” & _
“now be free of all password protection, so make sure you:” & _
DBLSPACE & “SAVE IT NOW!” & DBLSPACE & “and also” & _
DBLSPACE & “BACKUP!, BACKUP!!, BACKUP!!!” & _
DBLSPACE & “Also, remember that the password was ” & _
“put there for a reason。
Don’t stuff up crucial formulas ” & _
“or data。” & DBLSPACE & “Access and use of some data ” & _
“may be an offense。
If in doubt, don’t。”
Const MSGNOPWORDS1 As String = “There were no passwords on ” & _
“sheets, or workbook structure or windows。
” & AUTHORS & VERSION
Const MSGNOPWORDS2 As String = “There was no protection to ” & _
“workbook structure or windows。
” & DBLSPACE & _
“Proceeding to unprotect sheets。” & AUTHORS & VERSION
Const MSGTAKETIME As String = “After pressing OK button this ” & _
“will take some time。
” & DBLSPACE & “Amount of time ” & _
“depends on how many different passwords, the ” & _
“passwords, and your computer’s specification。
” & DBLSPACE & _
“Just be patient! Make me a coffee!” & AUTHORS & VERSION
Const MSGPWORDFOUND1 As String = “You had a Worksheet ” & _
“Structure or Windows Password set。
” & DBLSPACE & _
“The password found was: ” & DBLSPACE & “$$” & DBLSPACE & _
“Note it down for potential future use in other workbooks by ” & _
“the same person who set this password。
” & DBLSPACE & _
“Now to check and clear other passwords。” & AUTHORS & VERSION
Const MSGPWORDFOUND2 As String = “You had a Worksheet ” & _
“password set。
” & DBLSPACE & “The password found was: ” & _
DBLSPACE & “$$” & DBLSPACE & “Note it down for potential ” & _
“future use in other workbooks by same person who ” & _
“set this password。
” & DBLSPACE & “Now to check and clear ” & _
“other passwords。” & AUTHORS & VERSION
Const MSGONLYONE As String = “Only structure / windows ” & _
“protected with the password that was just found。
” & _
ALLCLEAR & AUTHORS & VERSION & REPBACK
Dim w1 As Worksheet, w2 As Worksheet
Dim i As Integer, j As Integer, k As Integer, l As Integer
Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer
Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer
Dim PWord1 As String
Dim ShTag As Boolean, WinTag As Boolean
Application。
ScreenUpdating = False
With ActiveWorkbook
WinTag = 。ProtectStructure Or 。ProtectWindows
End With
ShTag = False
For Each w1 In Worksheets
ShTag = ShTag Or w1。
ProtectContents
Next w1
If Not ShTag And Not WinTag Then
MsgBox MSGNOPWORDS1, vbInformation, HEADER
Exit Sub
End If
MsgBox MSGTAKETIME, vbInformation, HEADER
If Not WinTag Then
MsgBox MSGNOPWORDS2, vbInformation, HEADER
Else
On Error Resume Next
Do ‘dummy do loop
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
With ActiveWorkbook
。
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 。
ProtectStructure = False And _
。ProtectWindows = False Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application。
Substitute(MSGPWORDFOUND1, _
“$$”, PWord1), vbInformation, HEADER
Exit Do ‘Bypass all for。。。nexts
End If
End With
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
If WinTag And Not ShTag Then
MsgBox MSGONLYONE, vbInformation, HEADER
Exit Sub
End If
On Error Resume Next
For Each w1 In Worksheets
‘Attempt clearance with PWord1
w1。
Unprotect PWord1
Next w1
On Error GoTo 0
ShTag = False
For Each w1 In Worksheets
‘Checks for all clear ShTag triggered to 1 if not。
ShTag = ShTag Or w1。ProtectContents
Next w1
If ShTag Then
For Each w1 In Worksheets
With w1
If 。
ProtectContents Then
On Error Resume Next
Do ‘Dummy do loop
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
。
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 Not 。
ProtectContents Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application。
Substitute(MSGPWORDFOUND2, _
“$$”, PWord1), vbInformation, HEADER
‘leverage finding Pword by trying on other sheets
For Each w2 In Worksheets
w2。
Unprotect PWord1
Next w2
Exit Do ‘Bypass all for。。。
nexts
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
End With
Next w1
End If
MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADER
End Sub
本親自試確實(shí)錯(cuò)
謝寫段編碼同志。
win10和win?
如題所述
對(duì)于WIN7系統(tǒng)和win10系統(tǒng)怎么樣去選擇?
其實(shí)在選擇之前,主要是看硬件是否能夠支持,并且在安裝系統(tǒng)之后運(yùn)行其他程序可以保持流暢的運(yùn)行,再來決定究竟是裝win10系統(tǒng)還是WIN7系統(tǒng)?畢竟硬件決定了一切
并不只是說網(wǎng)上推薦的標(biāo)準(zhǔn)配置,就可以流暢的運(yùn)行WIN7,或者是windows10系統(tǒng),而且你要考慮到要運(yùn)行的是什么樣的程序?對(duì)于系統(tǒng)資源除了系統(tǒng)資源占用,是否有更多的資源去運(yùn)行其他程序?
現(xiàn)在的win10系統(tǒng)相比較,系統(tǒng)剛推廣時(shí),它的穩(wěn)定性以及,系統(tǒng)的各種bug,要少了很多,并且在之前的悟空答題也,也舉例說明過,在同等配置下,現(xiàn)在的win10系統(tǒng),在系統(tǒng)硬件的優(yōu)化性能方面要比WIN7系統(tǒng)高出15%甚至20%
第二就是硬盤的空間的劃分,使用過win10系統(tǒng)的人都知道win10系統(tǒng)在聯(lián)網(wǎng)之后會(huì)后臺(tái)進(jìn)行自動(dòng)更新,C盤的空間,如果預(yù)留過小可能用不了幾天,C盤的空間就會(huì)出現(xiàn)不足的現(xiàn)象,所以詢問過很多人win10系統(tǒng)C盤空間大概預(yù)留多少g?
其本推薦在60gb到80,相比較WIN7系統(tǒng),WIN7系統(tǒng)的C盤空間占用要小得多
所以做一個(gè)小的小編綜合來說
要用win10系統(tǒng),C盤的預(yù)留空間要大,WIN7系統(tǒng)并不需要
Windows10系統(tǒng)相比較WIN7系統(tǒng)硬件的優(yōu)化性要高一些
而且現(xiàn)在主流的硬件配置不管是臺(tái)式機(jī)或者是筆記本第七代第八代,都是支持win10系統(tǒng),WIN7系統(tǒng)可以安裝,可能會(huì)出現(xiàn)驅(qū)動(dòng)兼容性故障
所以綜合要考慮,自己的電腦硬件配置,使用習(xí)慣,對(duì)系統(tǒng)的兼容性,再來決定
windows7激活期限已過怎么辦?
可以用以下方法解決:
一、直接搜索下載、安裝個(gè)“wih7激活工具”即可**激活系統(tǒng)的。各大系統(tǒng)軟件網(wǎng)站都會(huì)有(這種方法一般都是破解板,有一定風(fēng)險(xiǎn))。
二、第一步的方法不行的話,那就直接換個(gè)可以自動(dòng)**激活的系統(tǒng)盤重裝系統(tǒng)就行了,這樣就可以全程自動(dòng)、順利解決系統(tǒng)**激活的問題了。
windows7激活期限已過怎么解決?
可以用以下方法解決:
一、直接搜索下載、安裝個(gè)“wih7激活工具”即可**激活系統(tǒng)的。各大系統(tǒng)軟件網(wǎng)站都會(huì)有(這種方法一般都是破解板,有一定風(fēng)險(xiǎn))。
二、第一步的方法不行的話,那就直接換個(gè)可以自動(dòng)**激活的系統(tǒng)盤重裝系統(tǒng)就行了,這樣就可以全程自動(dòng)、順利解決系統(tǒng)**激活的問題了
wincc運(yùn)行系統(tǒng)許可證如何破解?
網(wǎng)上有很多Wincc,STEP7以及TIA授權(quán),去**工控網(wǎng)上看看,注冊(cè)一下即可
原創(chuàng)文章,作者:九賢互聯(lián)網(wǎng)電腦百科小編,如若轉(zhuǎn)載,請(qǐng)注明出處:http://xiesong.cn/23485.html