Thread: Excel 2003 SP2 fires events without reason when saving workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alerion Alerion is offline
external usenet poster
  
Posts: 11
Default Excel 2003 SP2 fires events without reason when saving workbook
I have a very strange problem with events, to which I have not found an answer.
I have a workbook with dynamic comboboxes (selection in one changes
listfillrange in another etc.).
When I save the workbook (whether from File, SaveAs or by VBA code), several
change events fire in these comboboxes. This causes unwanted behaviour.
And yes, I have the Application.enableEvents set as false.

Would anyone have a clue why events fire without reason, or how to
circumvent the problem?

Alerion
Reply With QuoteReply With Quote