View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Anne Troy[_2_] Anne Troy[_2_] is offline
external usenet poster
 
Posts: 221
Default Pop-up when running a macro

First line of code after you declare your variables:
Sheets("Sheet3").Visible = True

Last line before you end sub:
Sheets("Sheet3").Visible = False
And don't use a .ScreenUpdating = False.
:)
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"tom" wrote in message
...
While I am running a Macro... I would like for the end user to see (Sheet
3 -
which is currenlty hidden) for the whole duration of the macro. After the
macro is completely done running I would like for (sheet 3) to hide again.

TFTH,
Tom