View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Stammers Chris Stammers is offline
external usenet poster
 
Posts: 8
Default Visual Basic - Invisible Command

Hello,

I have some macros written in VB Script that opens 2 different workbooks,
selects cells from one and pastes/special/values to the other. There are
multiple tabs in the destination files. There are 4 different macros in the
project with each set to call the next one. The script works fine however you
can see it flicking between each sheet as it is copying and pasting. Is there
a piece of code that will hide this? I am using Excel 2003.

Many thanks.
Chris