写在前面
关闭所有工作簿
Sub 关闭所有()
Dim wbs As Workbook
For Each wbs In Workbooks
wbs.Close SaveChanges:=True
Next wb
End Sub
添加到邮件附件
打开邮件默认客户端,并将当前文档作为附件添加到邮件中。
Sub 添加附件()
Application.Dialogs(xlDialogSendMail).Show
End Sub
文件备份
Sub 备份文件()
ThisWorkbook.SaveCopyAs Filename:=ThisWorkbook.Path & _
'' & Format(Date, 'mm-dd-yy') & ' ' & _
ThisWorkbook.name
End Sub
取消隐藏行列
Sub 取消隐藏()
Columns.EntireColumn.Hidden = False
Rows.EntireRow.Hidden = False
End Sub
突出显示行列
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim strRange As String
strRange = Target.Cells.Address & ',' & _
Target.Cells.EntireColumn.Address & ',' & _
Target.Cells.EntireRow.Address
Range(strRange).Select
End Sub
THE
END
创作不易,
您的支持是我坚持的动力,
劳烦动动手指转发、在看
联系客服