Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
xl2k on win2kPro.
I have a workbook that has a "Worksheet_SelectionChange" event on the initial sheet that works just fine. Once entry is complete the user runs a macro (located in a separate module) that copies the sheet (creates another sheet in the same workbook via "OrdEnt.Copy After:=OrdEnt"). Works fine, except; The worksheet change event can still be fired on the newly created (copied) sheet. I suppose I could copy/paste the sheet to get rid of the change event but was wondering if there's another way? Hints? -- Regards; Rob ------------------------------------------------------------------------ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to protect a worksheet from being copied to another worksheet | Excel Discussion (Misc queries) | |||
Event Procedures: Event on Worksheet to fire Event on another Worksheet | Excel Programming | |||
Copying Worksheet triggers Click event of combobox on another worksheet | Excel Programming | |||
macro to apply worksheet event to active worksheet | Excel Programming | |||
How name a copied worksheet? | Excel Programming |