View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Les Gordon Les Gordon is offline
external usenet poster
 
Posts: 4
Default Copying sheets without code

How can I move/copy a sheet into another workbook without taking the code
attached to the sheet with it?

In particular I have a menu that should only appear when a particular
worksheet is active. This is achieved through the activate and de-activate
events. When I copy the sheet to another workbook (through code) the event
handlers go with it (and crash since they can't find the function).

Do I have to go into the module behind the copied worksheet and delete the
code?

Regards

Les
--
Les Gordon