WorkSheet SelectionChange on a worksheet that doesnt yet exist

Hi,

I was wondering is it possible to create a worksheet selection change on a worksheet that will be created later on in my vba code?

I am trying to code this: http://img.chandoo.org/c/on-demand-c...-the-chart.png , but i want my macro to do some other stuff before the worksheet, where Private sub should be placed exists.

Sorry for my poor english.
Yours sincerely,

Johan

Your options are:

-use the workbook sheetselectionchange event and test for the name of the new worksheet before running the code within it
-use vba to create the code in the new worksheet object module when it is created

I would heavily recommend the first one because:
-it is much easier
-some security settings will block access to the vbproject reference of the vba object module that you need to create code within the workbook

Thanks guys for the help.
That sorted it out quite easily!