![]() TopMargin = Application.InchesToPoints(1.75) With Worksheets("AuditProgram").PageSetup CenterFooter = "&""Arial,Normal""&10" & CFTR With ThisWorkbook.Worksheets("AuditProgram").PageSetup WkshtNM = Worksheets("Headings").Range("APWkshtNm").ValueĬFTR = Worksheets("Headings").Range("TxTypName").Value Range("PrtOpt") = APĪpplication.Run "SUMacLib.xlsm!Templates"Īpplication.Goto reference:="AuditProgram!R1C1"ĬHDR = Worksheets("Headings").Range("APCHdr").Value NOTE: on form PrtDia that option PrtAPBtn is clicked. NOTE: on form MMDia that option C is picked. So it only runs like 4 lines of code before it crashes. NOTE: when it crashes on the macro, it crashes immediately. There is something related to a memory leak, print preview/page setup, and the way Excel views this specific worksheet. But I go back to the AuditProgram worksheet and it crashes on the macro? This doesn't make any sense to me. All the other worksheets work fine and do not crash even if I run the dialog boxes or macro, on those worksheets. If I run the macro from the "Macros" menu it crashes on the 8th round. If I add the macro to the quick access toolbar and click it from there, it crashes on the second round. ![]() If I hide the rows, it never crashes on the macro or Save. How can a dialog box corrupt a worksheet? The file will also crash on Save after running the macro then the two print dialog boxes. The macro works just fine if I never open the two dialog boxes. But when I go to run a macro that pulls up a form, it crashes. If I run these dialog boxes, while on this worksheet, it works fine. An Excel worksheet "AuditProgram" (NOT WORKBOOK) crashes when I run the "Page Setup" and the "Print Preview" dialog boxes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |