Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print preview creates problems in macro heavy reporting tool
Hello all,
I need help. I'm using an excel workbook as a temporary database in unison with SPSS and generating reports. I'm using one sheet as the temporary database, a couple more sheets to do some formatting and calculations, and 15 or so more sheets to generate the final outputs. The outputs are heavy in formulas and some contain graphs. Additionally, I'm running 6 modules to perform calculations, format sheets, and make dynamic changes. However, as soon as I print preview, print, or PDF a document, macros that search and replace go haywire. Has anybody come across a solution to this? Justin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print preview creates problems in macro heavy reporting tool
I've gotta wonder if you have a Workbook_BeforePrint macro that's running.
-- HTH, Barb Reinhardt " wrote: Hello all, I need help. I'm using an excel workbook as a temporary database in unison with SPSS and generating reports. I'm using one sheet as the temporary database, a couple more sheets to do some formatting and calculations, and 15 or so more sheets to generate the final outputs. The outputs are heavy in formulas and some contain graphs. Additionally, I'm running 6 modules to perform calculations, format sheets, and make dynamic changes. However, as soon as I print preview, print, or PDF a document, macros that search and replace go haywire. Has anybody come across a solution to this? Justin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell 2007 - Group of Charts Print Preview and/or Printing problems | Charts and Charting in Excel | |||
Excel 2007 - Problems using print preview and PDF/XPS conversion without having a printer defined | Excel Discussion (Misc queries) | |||
print preview problems in excel | Excel Discussion (Misc queries) | |||
Dashboard Reporting - plot area changes on print preview | Charts and Charting in Excel | |||
Problems Using Print Preview | Excel Worksheet Functions |