Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing Print Macro
Hi! Is there a way I can test a macro that prints 45 separate named ranges (45 sheets of paper) without actually printing? I am fairly new to this macro writting and I want to make sure it all works. Thanks!! -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=487186 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing Print Macro
Hi Brian,
Try usung the PrintPreview method: Worksheets("Sheet1").PrintPreview --- Regards, Norman "Brian Matlack" wrote in message ... Hi! Is there a way I can test a macro that prints 45 separate named ranges (45 sheets of paper) without actually printing? I am fairly new to this macro writting and I want to make sure it all works. Thanks!! -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=487186 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing Print Macro
Norman: I am currently selecting each named range and printing it and the moving on to the next range. Is there a way I can print preview all the pages in one preview (ther are 45 named ranges on 8 different worksheets)? If not! Per your suggestion I could insert the preview code instead o the print code and then just verify the view and when I close th preview window the macro should continue. Thanks! -- Brian Matlac ----------------------------------------------------------------------- Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350 View this thread: http://www.excelforum.com/showthread.php?threadid=48718 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing Print Macro
Hi Brian,
Try: Sheets.PrintPreview See also Ron de Bruin at: http://www.rondebruin.nl/print.htm#Print for numerous print tips. --- Regards, Norman "Brian Matlack" wrote in message news:Brian.Matlack.1ywidm_1132667703.0782@excelfor um-nospam.com... Norman: I am currently selecting each named range and printing it and then moving on to the next range. Is there a way I can print preview all the pages in one preview (there are 45 named ranges on 8 different worksheets)? If not! Per your suggestion I could insert the preview code instead of the print code and then just verify the view and when I close the preview window the macro should continue. Thanks!! -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=487186 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Testing Spreadsheet Cells while in a Macro | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Run only part of a macro for testing | Excel Programming | |||
Testing in a macro for bad range name? | Excel Programming | |||
Macro Date Testing | Excel Programming |