Hi,
I have a worksheet in which depending upon user selection one of the
available templates(other worksheets in the workbook)is copied to a new
sheet named as Input.
I have a combo box on the templates. And I have an event associated with
the comboBox (AxialDyn_CMB).
Private Sub AxialDyn_CMB_Change()
Call AxialDynSelection
End Sub
Now when I copy the template this code also get copied to the Input
sheet. When I change the selection in combo box on input worksheet excel
runs both the instances of above code i.e. it runs the"Private Sub
AxialDyn_CMB_Change()" for both the template and the Input worksheet.
I always thought that private subs are only associated for the sheet
they are written for. But this issue defies it.
Can anyone please help me with this.
Regards
Akansha
*** Sent via Developersdex
http://www.developersdex.com ***