Evagrius Ponticus
Well-known Member
- Joined
- May 24, 2007
- Messages
- 1,467
Hello,
I have code in the worksheet_calculate Event - the code is in the worksheet module of only one sheet. However, the code is called when changes are made to other sheets.
Is there a way to avoid this? The only way a user can cause changes to the worksheet is from a selection from controls combobox. Since the Worksheet Change event does not respond to sheet changes stemming from changes caused by selections from a control combobox, I had to use the calculate even. Thank you for any help.
I have code in the worksheet_calculate Event - the code is in the worksheet module of only one sheet. However, the code is called when changes are made to other sheets.
Is there a way to avoid this? The only way a user can cause changes to the worksheet is from a selection from controls combobox. Since the Worksheet Change event does not respond to sheet changes stemming from changes caused by selections from a control combobox, I had to use the calculate even. Thank you for any help.