View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default SCREEN NOT UPDATING

I think you will need to show us your code. It could be you have and error
handling routine that gets executed and that is not where you turn
ScreenUpdating back on at; or you could have a test that executes Exit Sub
before the ScreenUpdating is turned back on... there is no way for us to see
what is happening without being able to see your code.

--
Rick (MVP - Excel)


"ub" wrote in message
...
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