+ Reply to Thread
Results 1 to 1 of 1

If printer isn't found he prints at default printer

  1. #1
    Registered User
    Join Date
    01-22-2021
    Location
    antwerp, belgium
    MS-Off Ver
    ms 365
    Posts
    1

    If printer isn't found he prints at default printer

    hi guys

    i've been looking around but didn't found anything.

    At work the excel is been used by different people, but executed by 1. I wanted to make a button so that everyone just had to press the button and the correct printer starts.
    first I was strugling with te Ne ports but since that is fixed i have a new problem. if the printer isn't installed yet at their pc it just prints at their default. i'd like to have some kind of security that it stops the macro and shows a MsgBox.
    anyone that could help?

    this is what i have.

    Please Login or Register  to view this content.
    Last edited by davesexcel; 01-26-2021 at 12:50 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Printer Setup VBA to print active sheet - Still prints after Cancel
    By hans302 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-30-2017, 09:36 AM
  2. [SOLVED] Solution to changing Default printer code when printer changes
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-28-2016, 03:12 PM
  3. [SOLVED] ExecuteExcel4Macro, active printer - prints to another printer - worked on 2007!
    By wonderdunder in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-29-2015, 10:37 AM
  4. Can I pass printer properties to the default printer?
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2012, 04:11 PM
  5. macro to print 2 copies to default printer, then 1 copy to Adobe PDF printer
    By jwright650 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2011, 01:07 PM
  6. How do I create a macro that prints to any default printer
    By Wanna Learn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2006, 03:45 PM
  7. [SOLVED] printer prints 1/2 page then ejects
    By rfiler in forum Excel General
    Replies: 2
    Last Post: 12-22-2005, 10:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1