View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default stopping a print macro

Hi,

Holding down the CTRL key and tapping the Pause/Break key should interrupt
the macro but it may already have commited data to the print queue and that
will print.

Mike

"KateB" wrote:

I have a macro that will print 3 pages from a worksheet for 36 different
practices, i.e. 108 pages. However, once I click the button to run the macro
I can't seem to stop it! The Esc key does nothing - any advice please?

Kate