PDA

View Full Version : adding code to a sheet that is added at runtime



drawworkhome
11-29-2009, 07:47 PM
if i have a sheet that uses the selection change event to do x (call say, module6.exa) and i programmatically add a sheet in the future and want that same code module to apply to the new sheet also, is there a way to do so?
thx, cheers
erik:think:

lucas
11-29-2009, 08:23 PM
Personally, if I were faced with that I would create a hidden template sheet and just copy it.....

mikerickson
11-30-2009, 12:04 AM
ThisWorkbook has a Worksheet_SelectionChange event that would apply to newly added sheets.