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

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

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

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