Thread: macros over different sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default macros over different sheets
Application.ScreenUpdating = False
do_some_sutff
Application.ScreenUpdating = True

--
Gary''s Student - gsnu200783


"Robb.rich" wrote:

can you keep the current sheet viewable whilst a macro updates or copies from
another sheet, when i try this the screen jumps.
Reply With QuoteReply With Quote