1 Replies - 1054 Views - Last Post: 30 July 2012 - 07:27 PM Rate Topic: -----

#1 kirubagari  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 30-July 12

Print Header..Change font size and also the colour

Posted 30 July 2012 - 05:31 PM

kirubagari
Hi Experts,

Kindly help.This is my header

I need to make the font size the LOTID string bigger compare to other string..The string was appended with other string ..How the lot id font size can be set bigger?
Im calling print header function and the size of the header is standadized..What need to be done if i want to make LOTID string font bigger?

 sHeader = "/cABC MALAYSIA SDN BHD" _ 
                 + "/n/cNYNAME" _ 
                 + "/n/cNEWYORK , UNITED STATE" _ 
                 + "/n/n/c SUMMARY" _ 
                 + "/n/n/lLOT ID: " + rc.Lot.Id + "/n" 
      '  Define the header text 
     Me.vaTestData.PrintHeader = sHeader 



vatestData is the spreadsheet.

Kindly help

Is This A Good Question/Topic? 0
  • +

Replies To: Print Header..Change font size and also the colour

#2 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: Print Header..Change font size and also the colour

Posted 30 July 2012 - 07:27 PM

what have you tried so far? I don't find a PrintHeader property in Excel.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1