+ Reply to Thread
Results 1 to 2 of 2

Print a selected range of cells as pdf in a folder on the desktop Office 2011 - MAC

  1. #1
    Registered User
    Join Date
    09-09-2014
    Location
    D.C. Washinton
    MS-Off Ver
    Office Mac 2011 and Office 2013
    Posts
    3

    Print a selected range of cells as pdf in a folder on the desktop Office 2011 - MAC

    Hello everyone.

    I need a vba command that when activated it does the following:

    1) Saves a selected range of cells, in this case it is on a sheet call Reports in cells A1:I93, as a pdf on the desktop in a folder titled Test.
    2) The name of the PDF is in cell J86 also on the Reports worksheet
    3) All of the options for creating the pdf should be their defaults. So all I have to do is click the button and the pdf is created.

    The trick is that it has to work on a MAC with Office 2011

    Thanks again.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Print a selected range of cells as pdf in a folder on the desktop Office 2011 - MAC

    It would be best if you "create" the sub by recording your actions...

+ 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. Set print area of selected range then print preview if ok then print the document!
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 07:10 AM
  2. Counting cells by font colour - Office 2011 Mac
    By Really Simple in forum Excel General
    Replies: 1
    Last Post: 03-27-2014, 01:35 PM
  3. Excel 2011 0n Mac If cell value is 0 I do not want to print 0 on cells that refer to data
    By badgershalt in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 06-18-2013, 02:33 PM
  4. Printing a Selected Range to a specified folder as PDF
    By Shea0416 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2012, 12:32 PM
  5. how can i get office shortcut bar on the desktop?
    By sath in forum Excel General
    Replies: 3
    Last Post: 06-21-2006, 10:35 AM

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