adding a code to a new sheet

hi everybody ..
I have a code to put in the Sub Worksheet_Deactivate() ..
But my problem is that sheet doesn’t exist at the beginning
It will be added by a button click

Private Sub CB2_Click()
Sheets.Add
ActiveSheet.Name = "Stoke"
End Sub

So how can I add that code if the sheet has been added ???

all you are missing is the "Work" in the"Worksheets.add" line... it should be:

Worksheets.Add
ActiveSheet.Name = "Stoke"

Hope this helps.