我有一个宏,可以将一个工作表的行复制到另一个工作表。但是,我想保护这个工作表不被编辑。然而,当我这样做时,宏就无法运行了。我已经尝试了不同的锁定属性,但仍然无法运行。
我尝试过以下方法:
Option Explicit
Dim pwd As String
Dim ws As Worksheet
pwd = "password"
ws.Unprotect password:=pwd
Next ws
Sub FilterAndCopy()
Dim rng As Range, sht1 As Worksheet, sht2 As Worksheet
Set sht1 = Worksheets("SHIFT LOG")
Set sht2 = Worksheets("CHANGE OF NO'S")
sht2.UsedRange.ClearContents
With Intersect(sht1.Columns("B:BP"), sht1.UsedRange)
.Cells.EntireColumn.Hidden = False
If .Parent.AutoFilterMode Then .Parent.AutoFilterMode = False
.AutoFilter Field:=1, Criteria1:="Change of Numbers"
.Range("A:F, AD:AD, BL:BO").Copy Destination:=sht2.Cells(4, "B")
.Parent.AutoFilterMode = False
.Range("F:AD").EntireColumn.Hidden = True
.Range("AE:BK").EntireColumn.Hidden = True
End With
'Go to last cell in column B
With ActiveSheet
Range("B5").Select
Selection.End(xlDown).Select
End With
End Sub
ws.Protect password:=pwd
Next ws