Results 1 to 2 of 2

Macro Printing & Save as PDF Problem

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2014
    Location
    Kansas City, US
    MS-Off Ver
    Excel 2007
    Posts
    10

    Macro Printing & Save as PDF Problem

    New to using VBA in excel

    I've created buttons to be able to print the active sheet and to print the whole workbook less the hidden sheets. Is there a way to add code to make sure that excel is selecting the default printer?
    Active sheet code:
    ActiveWindow.SelectedSheets.PrintOut copies:=1, collate:=True
        Range("A3").Select
    End Sub
    Print whole workbook less hidden sheets code:
    Sub PrintVisible()
    Dim ws As Worksheet
    For Each ws In ThisWorkbook.Worksheets
        If ws.Visible = xlSheetVisible Then ws.PrintOut
    Next ws
    End Sub
    Help is much appreciated.
    Last edited by alexshaw76; 04-01-2014 at 12:02 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem with Macro printing code
    By Usethaschwarz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-25-2012, 08:56 AM
  2. Printing Macro Problem - Setting Default printer
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2012, 03:37 AM
  3. Macro using Save As Problem
    By mbmadiw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2006, 12:25 PM
  4. printing macro problem
    By icystorm@hotmail.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2006, 05:50 PM
  5. Excel printing macro problem
    By Cam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2006, 11:48 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