View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RandyPerry RandyPerry is offline
external usenet poster
 
Posts: 3
Default blank display while macro runs

I run a macro in Excel that starts on tab 1, then goes to tab 2,3,4,5,etc.
and when it is finished, it returns to tab 1. When the macro runs, each of
the screens (tabs) flash by as the macro works on that tabs data and then
returns back to the beginning (tab 1). How can I keep the screen (tab 1)
active as the macro goes to each tab since it will end up at tab 1 at the end
of the macro?