+ Reply to Thread
Results 1 to 2 of 2

Create macro to selet Printer for excel 2011 version

  1. #1
    Registered User
    Join Date
    09-30-2012
    Location
    Sacramento, Ca
    MS-Off Ver
    Excel 2008
    Posts
    11

    Create macro to selet Printer for excel 2011 version

    Hi

    I have this code that used with excel 2004 to select printer before you print but now I use the new version Excel 2011 and this code
    is not longer working because this version is not longer use Print preview

    I need help to create a new code with new version to be able select a printer before i print a sheet or label


    Sub Label()
    '
    ' Label Macro
    ' Macro recorded 11/7/2008 by User
    '
    '
    Sheets("LABEL").Select
    ActiveWindow.SelectedSheets.PrintPreview
    Sheets("OOW").Select
    Range("E28").Select
    End Sub


    Thanks

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Create macro to selet Printer for excel 2011 version

    Print Preview is no longer an option in Office for Mac 2011’s Excel and has been replaced by the "Page Layout View".

    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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