Hi All
How should I update a macro by a macro ? meaning to say that codes are replaced by new codes in module.
Suppose I have workbook named Ayaz.xls containing module named "TDP" which is protectd by VBA Password(Lock Project). I want codes to be updated/replaced by New codes.
For example I have following codes
want change to
Thanks in advance
How should I update a macro by a macro ? meaning to say that codes are replaced by new codes in module.
Suppose I have workbook named Ayaz.xls containing module named "TDP" which is protectd by VBA Password(Lock Project). I want codes to be updated/replaced by New codes.
For example I have following codes
Code:
Private Sub CopySheet1()
With Sheet1.UsedRange
Sheet2.Range("A1").Resize(.Rows.Count, .Columns.Count).Value = .Value
End With
End Sub
want change to
Code:
[/COLOR]
[COLOR=black]Private Sub CopySheet1()
With Sheet1.UsedRange
[COLOR=red]Sheet3.[/COLOR]Range[COLOR=red]("[/COLOR][COLOR=red]C2").[/COLOR]Resize(.Rows.Count, .Columns.Count).Value = .Value
End With
End Sub[/COLOR]
[COLOR=black]
Thanks in advance