Best Technique to clone worksheet
Tushar, Rich
Yes, application level events are the most powerful, and you *need* a
class module to get those.(you should study them though, understanding
them is vital to using events in Excel).
But sometimes you do not want those powerful events, just the same
events for a couple of selected sheets (remember unescesarely running
VBA events clears the XL UNDO stack, so do not run an application level
event to catch just one specific things within a few sheets, your UNDO
stack will be constantly cleared!). Then a class module that is
instantiated for just a few sheet wil catch just the events you want,
while not duplicating any code in any worksheet.
DM Unseen
|