Hello All,
I'm currently working on a workbook that has "Worksheet_Change" events on them. So here is the situation, i have a worksheet from a different workbook that i want to do a workbook open event in which when the workbook opens, it brings in a sheet from a different workbook and then adds on coding to the sheet. The new sheet has no coding, so i'd like to add something like this to the sheet
So it possible to add that to the new sheet.
Additionally lets say i would like to take that new sheet and send it back to it's original workbook. Is there a way to remove coding.
I'm currently working on a workbook that has "Worksheet_Change" events on them. So here is the situation, i have a worksheet from a different workbook that i want to do a workbook open event in which when the workbook opens, it brings in a sheet from a different workbook and then adds on coding to the sheet. The new sheet has no coding, so i'd like to add something like this to the sheet
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
'code
End Sub
So it possible to add that to the new sheet.
Additionally lets say i would like to take that new sheet and send it back to it's original workbook. Is there a way to remove coding.