copy cells

[geebee]

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

 

[Susan]

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

susan