Results 1 to 3 of 3

Print Sheet Name in the Header with Macro

Threaded View

  1. #1
    Registered User
    Join Date
    01-25-2012
    Location
    Brisbane
    MS-Off Ver
    Excel 2003
    Posts
    43

    Print Sheet Name in the Header with Macro

    Hi Experts

    Just wondering what property is require to print sheet name in the header NOT workbook name.

    I am trying the following code and getting an error message.

    Sub Header_SheetName()
    ActiveSheet.PageSetup.CenterHeader = ActiveWorksheet.FullName
    End Sub
    One more query I have is to set my print page order to Over, Then Down where as the default order is Down, Then Over.
    Any suggestions?


    Thanks
    Raj
    Last edited by raj.bris; 11-08-2013 at 02:59 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Assitance with macro to format, insert header and set print area
    By benji_tsl in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-30-2012, 10:49 AM
  2. Macro to automagically create a Banner Header with multiple pages to Print
    By iFaris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2012, 01:01 AM
  3. Macro tweak to ignore header row. +macro to copy from one sheet to another
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-16-2011, 03:21 PM
  4. Macro to Print Update and Print Sheet
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-26-2007, 11:10 AM
  5. [SOLVED] How can I print a different header on each page of an Excel Sheet
    By Fatrad in forum Excel General
    Replies: 2
    Last Post: 06-30-2005, 03:05 PM

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