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
------------------------------------------------------------------------
Bookmarks