View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike allen mike allen is offline
external usenet poster
 
Posts: 11
Default "running..." message

I have a routine that selects sheet after sheet doing various commands an
each sheet. I would prefer to NOT see the rapid flashing of sheet after
sheet being selected/opened. Can I do this in the background (not
viewable), or at least have a "cover" that hides the flashing of sheet
selections that reads: "running, be patient, please."? thanks

sub manysheets()
sheets("1").select
'copy cell A1 and paste in B1
sheets("2").select
'copy cell A1 and paste in B1
sheets("3").select
'any various functions
end sub