ExcelBanter - View Single Post - Avoiding duplication in objects with large commonality

Jamie Collins

(Andrew) wrote ...

Re the tweaks that you mention - I had read that these lines can
sometimes get overwritten when making changes to your code so I have
tended to steer away from them. Have you had any problems with this?
Maybe it is only an issue if you change the actual collection class
object?

Yes but only occasionally and it's not too much of a pain to put them
back in. I think you have to change the procedures themselves (e.g.
add white space then delete could do it) to erase the hidden lines.

I changed my template so that the two sub procedures with the hidden
lines are together and are straddled by the _initialize and _terminate
events (no white space) which I amend rarely and with care. the
procedures themselves never need to change.

Definitely worth the extra time and trouble.

Jamie.

--