On Wednesday, November 7, 2012 12:09:13 PM UTC-5, Bobby wrote:
Explanations:



1.I insert sheet



Sheets.Add

ActiveSheet.Name = demo





2.I would like to dynamically insert the following code in the newly created sheet:





Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Call Module35.checkselection(Target)

End Sub



The purpose is to permit a user selection on specific cells.



Thank's in advance

Ben I get a subscript error on a new sheet???
Any idea?
Thank's