error trapping

L

libby

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Application.top=0 fails 3
Printing Problems 5
Run time error 2
Error trap only works once 2
Problem with "Application.Goto Reference" code line 4
Active printer 1
error 1004 6
1004 error when using ATPVBAEN.XLAM!Regress 7

Top