Thread: block event
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roman Töngi Roman Töngi is offline
external usenet poster
 
Posts: 6
Default block event

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