LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Stop Dialog box from appearing within macro

I have the following macro which intercepts the printing on a particular
spreadsheet as I need to set certain criteria before the sheets are printed.

Although this then calls the individual macros, which then in turn print out
the relevant sheets all ok afterwards it loads up the print dialog box still.

Is it possible to stop the print dialog box from showing?

Appreciate any help that you can offer on this.

Many Thanks, Al Mackay ( )
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
stop False from appearing Dale G[_2_] New Users to Excel 8 July 26th 08 08:24 PM
How to stop the last record always appearing when I Autofilter TAG Excel Discussion (Misc queries) 1 July 26th 06 12:48 PM
How to stop reviewing bar from automatically appearing ChAnDeRu Excel Discussion (Misc queries) 12 July 9th 05 02:13 PM
How do I stop the template help from appearing on startup Allan_D_Ziegler Excel Discussion (Misc queries) 0 July 6th 05 04:24 AM
how do I stop this appearing.......#DIV/0! Scudo New Users to Excel 5 July 3rd 05 01:14 AM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"