I have a workbook with an open event that opens another workbook, gets some data from it, and closes it. The main workbook has a listbox that is populated from that data. I set ScreenUpdating to false for the process.

The problem is the list box appears empty when ScreenUpdating is turned back on. (It's not really empty, if I scroll of the screen and back on it's all there.) Also, if I don't disable ScreenUpdating, this problem does not occur.

Why is it doing this and how do I make it stop?

thanks