Thread: Suppressing screen flicker when sheet is activated
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
james james is offline
external usenet poster
  
Posts: 3
Default Suppressing screen flicker when sheet is activated
if all you want to do is swap sheets, you could instead use:

Sheets("Sheet_Name").Select

it seems not to show when screenupdating is false.
Reply With QuoteReply With Quote