Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 233
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel File Mirror/Clone Goaliemenace Excel Discussion (Misc queries) 2 May 10th 10 08:42 PM
Ebay clone Ebay clone script RUN YOUR OWN AUCTION SITE hael_dermu Excel Discussion (Misc queries) 0 October 25th 08 05:26 AM
Clone worksheets? bmartucci Excel Worksheet Functions 2 January 2nd 07 07:03 PM
is there anyway to create a clone of an excel sheet in vba? Daniel Excel Worksheet Functions 2 July 6th 05 09:41 AM
Control Button Clone Phil Hageman[_3_] Excel Programming 3 January 28th 04 03:31 PM


All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"