hi,

i have the following:

Dim wks As Worksheet
Set wks = Worksheets.Add(After:=Sheets("xyz"))
Sheets("tester").Cells.Copy Destination:=wks.Range("A1")

please note that the "tester" sheet has a combobox. for some reason when i
invoke the code to create the new sheet from the "tester" sheet, the OnChange
event of the combobox is triggered. how can i prevent this annoying thing
from happening when i create a new sheet?

thanks in advance,
geebee

either change the name of the "tester" sheet, or change the name of
the combobox............
excel can't decide which one you mean.

susan



On Jun 10, 9:41*am, geebee <geraldj...@hotmail.com(noSPAMs)> wrote:
> hi,
>
> i have the following:
>
> Dim wks As Worksheet
> * * Set wks = Worksheets.Add(After:=Sheets("xyz"))
> * * Sheets("tester").Cells.Copy Destination:=wks.Range("A1")
>
> please note that the "tester" sheet has a combobox. *for some reason when i
> invoke the code to create the new sheet from the "tester" sheet, the OnChange
> event of the combobox is triggered. *how can i prevent this annoying thing
> from happening when i create a new sheet?
>
> thanks in advance,
> geebee