View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ajmplanner ajmplanner is offline
external usenet poster
 
Posts: 5
Default Hiding automated spreadsheet activity

I have an excelspreadshett with several sheets. I have automated the
spreadsheet with VB Excel. There is a lot of activity moving data from one
spreadsheet to another. In action, it is very disturbing to the user as the
code switches back and forth between sheets, across columns, etc. It gives a
fast flickering effect.

How can I hide this activity while hte code is executing?

Thanks in advance for a reply.