+ Reply to Thread
Results 1 to 1 of 1

Excel for Mac: save sheet as pdf disables printer communication?

  1. #1
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Excel for Mac: save sheet as pdf disables printer communication?

    Hi all!
    I have a workbook that saves sheets as pdf and send them to the printer.

    Problem is that once a sheet is saved as pdf no sheets are sent to the printer until the workbook is closed and reopened again.
    Looks like saving as pdf disables printer communications.

    The issue occurs only on Mac (Macintosh (Intel) Version 10.15.4 (Build 19E287) and works fine on Windows.
    Extra problem for me is that I don't have a Mac. Searching the web for this problem delivered no results.

    The actual workbook having the problem is too big and complex to post here, but I'm attaching a small demo workbook which shows the same issue.
    The demo opens with a userform having one button.
    When the button is clicked the sheet is sent to the printer and then saved as pdf.
    The first time the button is clicked the sheet is printed and saved, but all following times it's clicked nothing is sent to the printer.

    Hope there's someone outthere having a Mac and recognizes this issue or can point me in a direction how to solve this.
    Attached Files Attached Files
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

+ 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. Print each sheet to PDF Printer NOT Using Save as PDF Function
    By esposit513 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2018, 05:23 PM
  2. Replies: 1
    Last Post: 06-30-2017, 10:29 AM
  3. Save Excel Printer Settings
    By cheal2 in forum Excel General
    Replies: 1
    Last Post: 07-10-2013, 07:13 PM
  4. Save as name change disables Macros
    By tiggatattoo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2011, 10:12 AM
  5. Code, that disables save, save as and close commands
    By mgmetev in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2009, 06:31 PM
  6. Communication between Excel sheet & USB port
    By GZimmer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2009, 08:18 AM
  7. [SOLVED] Protecting sheet disables import of extetrnal data in Excel 2003
    By MNord in forum Excel General
    Replies: 0
    Last Post: 08-31-2005, 12:05 PM

Tags for this Thread

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