Arcticwarrio
Active Member
- Joined
- Dec 6, 2005
- Messages
- 439
Hello again all.
Probably a simple one this so i'll keep it short,
i have a sheet called Template with this code
i have another script than unhides a sheet and copys whats in the template to it.
Simply put i want to copy this script to it too.
i used a copy and add sheet method but i need to be able to do this in a shared workbook, hence the hidden sheets instead.
thanks again.
Arctic.
Probably a simple one this so i'll keep it short,
i have a sheet called Template with this code
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And Target.Row = 2 Then
If Target.Cells.Count <> 1 Then Exit Sub
boo = Target.Value
boobs = Target.Offset(-1, 0).Value
nocold = 4
WO_update_cust
End If
If Target.Column = 2 And Target.Row = 3 Then
If Target.Cells.Count <> 1 Then Exit Sub
boo = Target.Value
boobs = Target.Offset(-2, 0).Value
nocold = 5
WO_update_cust
End If
End Sub
i have another script than unhides a sheet and copys whats in the template to it.
Simply put i want to copy this script to it too.
i used a copy and add sheet method but i need to be able to do this in a shared workbook, hence the hidden sheets instead.
thanks again.
Arctic.