M
Marco Margaritelli
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!
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!