adding a code to a new sheet

[rana_shaker]

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

Please Login or Register  to view this content.

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

[par315]

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

Please Login or Register  to view this content.

Hope this helps.