How can i use VBA to put a programcode to a worksheet
For example
- I have a worksheet called "A700".
- There is no VBA code in it.
- Now i want to use VBA to add the next code to the worksheet "A700".
Private Sub Worksheet_Activate()
ActiveWorkbook.Names("Persoon").Delete
End Sub
Somebody an idea?
For example
- I have a worksheet called "A700".
- There is no VBA code in it.
- Now i want to use VBA to add the next code to the worksheet "A700".
Private Sub Worksheet_Activate()
ActiveWorkbook.Names("Persoon").Delete
End Sub
Somebody an idea?