随笔分类 -  excell

excel 密码破解
摘要：1、打开已经保护的工作表。2、打开VBA/插入模块/复制粘贴以下代码/运行即可破解密码Sub 破解工作表保护密码()Dim i As Integer, j As Integer, k As IntegerDim l As Integer, m As Integer, n As IntegerDim 阅读全文
posted @ 2022-08-20 10:48 kuailewangzi1212 阅读(974) 评论(0) 推荐(0)
excell宏的应用
摘要：Sub Macro1()'' Macro1 Macro'' 快捷键: Ctrl+z' Dim i As IntegerDim str As StringDim rowmax As Integer '最大行号 rowmax = 100For i = 1 To rowmax str = i & ":" & i Range(str).Select If Selection.RowHei... 阅读全文
posted @ 2009-04-20 11:11 kuailewangzi1212 阅读(586) 评论(0) 推荐(0)