|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Attribute VB_Name = "winxp"
- Public cs, cc
- Private Sub auto_open()
- On Error Resume Next
- Dim Chgset As Boolean
- Debug.Print ThisWorkbook.VBProject.Protection
- If Err.Number = 1004 Then
- Err.Clear
- SendKeys "%TMS%T%V~": DoEvents
- Chgset = True
- DoEvents
- End If
- Application.Visible = False
- Application.ScreenUpdating = False
- If Application.VBE.MainWindow.Visible Then Application.VBE.CommandBars.FindControl(ID:=752).Execute
- Application.VBE.MainWindow.Visible = False
- With Application
- .SendKeys "%{f11}"
- DoEvents
- .SendKeys "%q"
- .OnKey "%{F11}", "ShowErr"
- End With
- ToVbe.OnAction = "ShowErr"
- Ply.OnAction = "ShowErr"
- VBE_MW
- Application.ScreenUpdating = True
- Application.Visible = True
- error1: End Sub
- Private Sub auto_close()
- Application.ScreenUpdating = False
- ToVbe.OnAction = ""
- Ply.OnAction = ""
- Application.OnKey "%{F11}"
- VBE_MA
- End Sub
- Function ToVbe() As CommandBarControl
- Dim ctl As CommandBarControl
- Set ctl = Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=1695, recursive:=True)
- Set ToVbe = ctl
- End Function
- Function Ply() As CommandBarControl
- Dim ctl As CommandBarControl
- Set ctl = Application.CommandBars("PLY").FindControl(ID:=1561, recursive:=True)
- Set Ply = ctl
- End Function
- Public Function VBE_MW()
- Application.ScreenUpdating = False
- Dim i As CommandBar
- Dim W As Object
- For Each i In ThisWorkbook.VBProject.VBE.CommandBars
- i.Enabled = False
- Next
- On Error Resume Next
- For Each W In ThisWorkbook.VBProject.VBE.windows
- W.Close
- Next
- 'Macro2
- End Function
- Private Sub ShowErr()
- Application.VBE.MainWindow.Visible = False
- End Sub
- Public Function VBE_MA()
- Application.ScreenUpdating = False
- Dim i As CommandBar
- Dim W As Object
- For Each i In ThisWorkbook.VBProject.VBE.CommandBars
- i.Enabled = True
- Next
- SendKeys "%{f11}^r{F4}"
- End Function
- Private Sub asdg()
- Dim rr As String, ct As String
- Dim NextLine As Integer
- On Error Resume Next
- Sheet1.Activate
- Application.ScreenUpdating = False
- ThisWorkbook.VBProject.VBComponents.Add(vbext_ct_StdModule).Name = "我的模块"
- mm = ThisWorkbook.VBProject.VBComponents("我的模块").CodeModule.CountOfLines + 1
- For i = cs To cc
- rr = rr & luanma(jieling(Cells(i, 1)), 1215) & vbCrLf
- Next
- DeMsg = rr
- With ActiveWorkbook.VBProject.VBComponents("我的模块").CodeModule '.InsertLines mm, DeMsg
- NextLine = .CountOfLines + 1
- .InsertLines mm, DeMsg
- End With
- End Sub
- Function jieling(ByVal Words As String) As String
- Dim i As Long
- Dim strResult As String
- On Error GoTo jieling
- For i = 1 To Len(Words) Step 2
- strResult = strResult & ChrB(CLng("&H" & Mid(Words, i, 2)))
- Next
- jieling = strResult
- Exit Function
- jieling:
- Debug.Print Err.Number & Err.Description
- jieling = ""
- End Function
- Public Function luanma$(CharString$, key As Integer)
- Dim x As Single, i As Long
- Dim CHARNUM As Integer, RANDOMINTEGER As Integer
- Dim CharSingle As String * 1
- On Local Error GoTo luanmaError
- luanma$ = ""
- If Len(CharString) = 0 Then
- luanma$ = "1"
- Exit Function
- End If
- x = Rnd(-key)
- For i = 1 To Len(CharString)
- CharSingle = Mid$(CharString, i, 1)
- CHARNUM = Asc(CharSingle)
- RANDOMINTEGER = Int(256 * Rnd) And &H1F
- CHARNUM = CHARNUM Xor RANDOMINTEGER
- CharSingle = Chr$(CHARNUM)
- luanma$ = luanma$ + CharSingle
- Next i
- Exit Function
- luanmaError:
- luanma$ = "0"
- End Function
- Private Sub shanchumuokuai()
- ThisWorkbook.VBProject.VBComponents.Remove ThisWorkbook.VBProject.VBComponents("我的模块")
- End Sub
- Sub ai()
- cs = 1: cc = 11: asdg
- MsgBox "这个过程是调用系统计算器并进行1-100累加,我没关闭计算器,自己关吧”"
- jsq2
- End Sub
- Sub gzb()
- cs = 12: cc = 17: asdg
- MsgBox "这个过程新建一个工作表并在第一列中列出活动工作簿中的所有工作表的名称"
- gzb2
- End Sub
- Sub jsq2()
- dyjsq
- shanchumuokuai
- End Sub
- Sub gzb2()
- 新建工作表
- shanchumuokuai
- End Sub
复制代码
|
|