Thread
:
error trapping
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
error trapping
post all of your code relating to this
--
Don Guillett
SalesAid Software
"libby" wrote in message
...
Hi
I'm having real trouble trapping this error.
I have a sub where the active printer is changed
Application.ActivePrinter = ListBox1.value
if the printer is networked then it works fine, but if it
isn't I get a run-time error 1004
Method 'ActivePrinter' of object'_Application' failed
Is there any way I can user On Error GoTo Errorhandler to
display the message "Printer Not Mapped" if this happpens?
Thanks in advance
Libby (xl97)
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]