Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel File Mirror/Clone | Excel Discussion (Misc queries) | |||
Ebay clone Ebay clone script RUN YOUR OWN AUCTION SITE | Excel Discussion (Misc queries) | |||
Clone worksheets? | Excel Worksheet Functions | |||
is there anyway to create a clone of an excel sheet in vba? | Excel Worksheet Functions | |||
Control Button Clone | Excel Programming |