Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I created (recorded) a very simple macro that "Select an area", "Select a
printer", and "Print". It works the first time, (while recording it), but when I Play It again, It FREEZES Excel and the whole PC! The SAME Macro works just fine just changing the "Preview:=" statement from "False" to "true". =============================================== THIS ONE BELOW WORKS JUST FINE!!! =============================================== Sub Button8_Click() ' ' Button8_Click Macro ' Macro recorded 6/6/2009 by Marco Margaritelli ' ' Range("B3:C5").Select ActiveSheet.PageSetup.PrintArea = "$B$3:$C$5" Application.ActivePrinter = "DYMO LabelWriter Twin Turbo on Ne04:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "DYMO LabelWriter Twin Turbo on Ne04:", Collate:=True, Preview:=True Range("E3").Select End Sub =============================================== THIS ONE BELOW DOES NOT WORK... IT FREEZE UP EXCEL AND EVERYTHING ELSE IN THE PC! =============================================== Sub Button8_Click() ' ' Button8_Click Macro ' Macro recorded 6/6/2009 by Marco Margaritelli ' ' Range("B3:C5").Select ActiveSheet.PageSetup.PrintArea = "$B$3:$C$5" Application.ActivePrinter = "DYMO LabelWriter Twin Turbo on Ne04:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "DYMO LabelWriter Twin Turbo on Ne04:", Collate:=True, Preview:=False Range("E3").Select End Sub ================================================== = This happen in ALL Excel Macros I created and that have been working Just fine for years! I never had this problem since a few months ago (I believe after a MS Security Update...). I hope someone could clear this "MISTERY!" THANKS! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Macro runs fine, but freezes if I try to do ANYTHING else whileit's running | Setting up and Configuration of Excel | |||
Macro freezes spreadsheet | Excel Discussion (Misc queries) | |||
Simple macro (ClearContent) freezes Excel | Excel Programming | |||
Macro freezes up Excel | Excel Programming | |||
Macro freezes Excel | Excel Programming |