View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bobby[_4_] Bobby[_4_] is offline
external usenet poster
 
Posts: 53
Default Flashing screen even with Application.ScreenUpdating = False

I am trying to pivot and hide between 2 sheets and make it look professional.

Event with this code I get the flashing screen as soon as the sheet gets visible.
Is there an other option that I could use?

Application.ScreenUpdating = False

If Sheets("Selection").Visible = False Then Sheets("Selection").Visible = True
Sheets("Selection").Select

Thank's ahead.