would like to block the "ComboBox1-change"-event until
the code in "Workbook_load" has processed completely.
one sulution could be to set a variable in a module, which
is observed by "ComboBox1-change" at the beginning.
if that variable is 0 then abort otherwise continue.
At the end of "Workbook_load" that variable is set to 1.
Does anyone know a better solution.

Thank
Roman

Roman,

What is the problem with that solution?


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Roman Töngi" wrote in message
...
would like to block the "ComboBox1-change"-event until
the code in "Workbook_load" has processed completely.
one sulution could be to set a variable in a module, which
is observed by "ComboBox1-change" at the beginning.
if that variable is 0 then abort otherwise continue.
At the end of "Workbook_load" that variable is set to 1.
Does anyone know a better solution.

Thank
Roman