我已经编写了一个小的VBA脚本,但是我在完全关闭工作簿方面遇到了困难。我可以关闭工作簿,但是注意到它仍然在VBA编辑器中显示。我已经看到其他表格上放置一些代码来完全关闭所有内容,但我无法使其正常工作。
有人能为我指点迷津吗?
Private Sub PNTXLXS_Click()
Application.DisplayAlerts = False
Application.EnableCancelKey = xlDisabled
RCD_PNT.Hide
With Sheets("Clash List").UsedRange
mr = .Rows.Count
mc = .Columns.Count
.Range(Cells(1, 26), Cells(mr,mc)).SpecialCells(xlCellTypeVisible).Copy
End With
Workbooks.Add
Application.Visible = True
With ActiveSheet.Range("A1")
.PasteSpecial Paste:=xlPasteValues
.PasteSpecial Paste:=xlPasteFormats
End With
With Selection
.WrapText = False
.EntireColumn.AutoFit
.WrapText = True
End With
InitialName = Range("A1") & " - " & Format(Now(), "DDMMYY")
filesavename = Application.GetSaveAsFilename(InitialFileName:=InitialName,
fileFilter:="Excel Files (*.xlsx), *.xlsx")
ActiveWorkbook.SaveAs FileName:=filesavename
ActiveWorkbook.Close
我知道这是需要关闭VBA文件的位置,对吗?
Application.CutCopyMode = False
Application.DisplayAlerts = True
End Sub
谢谢
马克
Option Explicit
! 什么是RCD_PNT
? - Storax