| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Sheet causes Combo Box change event to fire on original sheet
Hi All,
I have a model with 1 tab containing 2 combobox controls. Often I'll need to copy this sheet to model a different scenario and when I do so the copy event fires a change event on the first combobox in the original sheet. Normally I wouldn't be concerned however, when it does fire all my data is cleared per the change event. Is there anyway to stop this change event from firing when I copy the sheet? Thanks in advance for any help. AJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet Change Event - copy cell to another sheet | Excel Discussion (Misc queries) | |||
| Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
| Why does change event fire when workbookclosed | Excel Programming | |||
| Fire Event only when Cell Change? | Excel Programming | |||
| How do I get Pivot filter change event to fire? | Excel Programming | |||
Threaded Mode
