View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_5_] Stuart[_5_] is offline
external usenet poster
 
Posts: 413
Default Sheet code module question

A routine runs, whereby the contents of a workbook are copied
to a new workbook. This new workbook contains one single
worksheet. It has no standard modules, and the Thisworkbook
module is empty. However, there is still code in the new sheet's
Sheet module (specifically Worksheet_SelectionChange Event
code).

I understand this cannot be deleted.

If that is the case, can I prevent it being copied into the new
worksheet in the first place?

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.735 / Virus Database: 489 - Release Date: 06/08/2004