Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Doing a "print preview" slows down an Excel 2003 COM addin.
My COM Addin running under Excel 2003 slows down 100% when a print preview
has been done anywhere in the workbook. A workaround is to save a custom view of the worksheet before doing a page setup (or print preview?) and restoring this (empty) view after doing the print jobs. However this is not always convenient. Be nice if it could be fixed. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Doing a "print preview" slows down an Excel 2003 COM addin.
Thanks Nick,
Works Fine "NickHK" wrote: Have you tried setting ActiveSheet.DisplayPageBreaks = False after the preview ? NickHK "gordon garnsey" <gordon wrote in message ... My COM Addin running under Excel 2003 slows down 100% when a print preview has been done anywhere in the workbook. A workaround is to save a custom view of the worksheet before doing a page setup (or print preview?) and restoring this (empty) view after doing the print jobs. However this is not always convenient. Be nice if it could be fixed. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving an excel "print preview" view | New Users to Excel | |||
Why is the "zoom" option grayed out in "print preview?" | Excel Discussion (Misc queries) | |||
set Print Preview to "preview" page that was being worked on? | Excel Discussion (Misc queries) | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
Excel spreadsheet print preview error "nothing to print" | Excel Discussion (Misc queries) |