Results 1 to 7 of 7

bug fix print title code

Threaded View

BoundToExcel bug fix print title code 10-20-2015, 03:15 PM
jolivanes Re: bug fix print title code 10-20-2015, 03:20 PM
BoundToExcel Re: bug fix print title code 10-20-2015, 03:47 PM
BoundToExcel Re: bug fix print title code 10-20-2015, 03:55 PM
alansidman Re: bug fix print title code 10-20-2015, 04:00 PM
jolivanes Re: bug fix print title code 10-20-2015, 04:05 PM
BoundToExcel Re: bug fix print title code 10-20-2015, 04:19 PM
  1. #1
    Registered User
    Join Date
    10-20-2015
    Location
    Philadelphia,PA
    MS-Off Ver
    2013
    Posts
    31

    bug fix print title code

    So I currently have a problem with my code where when I run it and attempt a print view to see if my code is working, it appears as if it is copying over a whole chunk of my page 1 into every other page that is on the same sheet. The cells are linked directly and update whenever I update the cells it copies from. I'm sure it has something to do with my print title code but I'm not a good enough macroer to understand why its not working, any help would be much appreciated.

    Sub Printing_Preference()
    'Printer Preferences Macro Coding
    
    
    Worksheets("Sheet1").Activate
    ActiveSheet.PageSetup.PrintTitleRows = ActiveSheet.Rows(1).Address
    ActiveSheet.PageSetup.PrintTitleColumns = _
        ActiveSheet.Columns("A:H").Address 'Set the columns that have important header cells
        
    
    With Worksheets("Sheet1").PageSetup 'Set the page setup below this line, all page setup values can be found here https://msdn.microsoft.com/en-us/lib.../dn254188.aspx
        .BlackAndWhite = False 'True sets the printer to print in black and white, false sets the printer to print in color
        .LeftMargin = Application.InchesToPoints(0.5) 'left margin in inches, normal size is 0.7
        .RightMargin = Application.InchesToPoints(0.5) ' right margin in inches, normal size is 0.7
        .TopMargin = Application.InchesToPoints(0.5) 'top margin in inches, normal size is 0.75
        .BottomMargin = Application.InchesToPoints(0.5) 'bottom margin in inches, normal size is 0.75
        .HeaderMargin = Application.InchesToPoints(0.2) 'header margin in inches, normal size is 0.3
        .FooterMargin = Application.InchesToPoints(0.2) 'footer margin in inches, normal size is 0.3
        .PaperSize = xlPaper11x17 'Set paper size to tabloid 11x17, other options are found at https://msdn.microsoft.com/en-us/lib.../ff839964.aspx
        .PrintArea = False 'Sets printing area to be the entire workbook, in order to set this as a specific area in the workbook, see the line below
        'ActiveSheet.PageSetup.PrintArea = "$A$1:$G$11" 'Set printing area to be in the range specified within the quotations
        .Orientation = xlLandscape 'Sets printing orientation to Landscape, use xlPortrait to set orientation to portrait
        .PrintHeadings = False 'Sets the row/column headings to print if the value is true, sets them to not print if the heading is false, i.e. Row A, Row B, Row C..etc., Column A, Column B, Column C..etc.
        
        
    End With
    
    
    
    End Sub

    problem solve.PNG
    Last edited by alansidman; 10-20-2015 at 04:00 PM. Reason: codee tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Print button in userform's title bar
    By mani_bbc05 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2013, 04:36 PM
  2. [SOLVED] Print column title of greater value
    By bh2 in forum Excel General
    Replies: 1
    Last Post: 06-13-2012, 02:44 PM
  3. print title on all pages
    By legolas in forum Excel General
    Replies: 2
    Last Post: 05-07-2008, 03:44 AM
  4. Print Title function alternative?
    By twosted in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 04-10-2008, 09:01 AM
  5. Print Title
    By Schlic in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-22-2008, 02:28 AM
  6. Replies: 2
    Last Post: 02-02-2006, 01:45 PM
  7. How do I set up an additional print title in Excel?
    By Sally in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-10-2005, 12:06 PM

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