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
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
Personally, if I were faced with that I would create a hidden template sheet and just copy it.....
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
ThisWorkbook has a Worksheet_SelectionChange event that would apply to newly added sheets.