G
Guest
Guest
I'm using MS Excel 97. A worksheet has a combo box with vba code associated with it. When the combo box changes, so does data on a chart.
The problem, however, is that the code in the combo box runs when I close the file. Why? (I don't want the code to run. Plus, I don't have any code elsewhere in the file where the OnClose event is used.) I don't understand why this happens when the code is in a private sub within the combo box control.
Can anyone explain, and come up with a solution?
Thanks,
Pete
The problem, however, is that the code in the combo box runs when I close the file. Why? (I don't want the code to run. Plus, I don't have any code elsewhere in the file where the OnClose event is used.) I don't understand why this happens when the code is in a private sub within the combo box control.
Can anyone explain, and come up with a solution?
Thanks,
Pete