Hi
I have a listbox in my sheet and a comadbutton that runs a macro.
I select a name from the list and click on command button.
I have application.screenupdating= False at the start of the macro and
application.screenupdating= true at the end of the macro.
but after the macro is done, and when I click on the list box, I am not able
to select an item from the list. I have to click on to the worksheet 2 or 3
times to be able to select from listbox.
Though If I dont have screenupdating commands in the macro, I am able to
select an item from list box after macro is done.
But since my macro opens and closes another workbook, I want screenupdating
set to false and then set to true.
Any advise what could be the problem