Barb:
Thank you for your reply.
Well, I removed the line: Application.ActivePrinter = "Zebra LP2844ps on
Ne00:"
but still the same problem: No printing and everything frezes...

Furthermore, I really need this line because the Zebra LP2844 is NOT my
default printer. You see this is a simple macro that prints an Address Label
on the Zebra LP2884, then copy the address and past it to another page to
print a letter on my other printer (HP5000).

"Barb Reinhardt" wrote:

I'm guessing you don't need this line at all. Comment it out and see what
happens.

Application.ActivePrinter = "Zebra LP2844ps on Ne00:"

--
HTH,
Barb Reinhardt




"Marco Margaritelli" wrote:

Using Win XP Pro (SP2) + Office 2003

After many years using the same worksheet containing the same macros, these
(ALL) have stopped working.
When I click the button that call the macro, Excel and I have to close it
with CTRL+ALT+DEL.

Thinking that was something wrong with the macro itself, I created a new
sheet with a very simple macro:

Here it is:
============================

Sub Button5_Click()
'
' Button5_Click Macro
' Macro recorded 9/6/2008 by Marco Margaritelli
'
'
Range("A1:B2").Select
Application.ActivePrinter = "Zebra LP2844ps on Ne00:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Zebra LP2844ps on Ne00:", Collate:=True
End Sub

================================

This print function worked when I was creating the macro, the I save it, and
clicked the Button just created that call for this macro and even this simple
script freezes everything, BUT if I manualy run this one from the MS Visual
Basic VBA "Run-F5" function it works, BUT NOT if I call it from the button
created to run this macro...
Kind of weird...

A few days ago I re-installed Office 2003 and the problem was solved...
Now it is happening again... I did NOT install any new software... I even
disable McAfee from Script Scanning and its "System Guard", just in case...

Everything else in Office 2003 seems to be working fine, even Excel it is
fine, the problem is ONLY the unability of running macros.
I need them!...
Any suggestions?

THANKS!