+ Reply to Thread
Results 1 to 1 of 1

VBA Apply Font and Size to Headers and Footers

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    NA
    MS-Off Ver
    Excel 2013
    Posts
    34

    VBA Apply Font and Size to Headers and Footers

    Here's the gist - File names in my workplace require basic headers and footers and I wish to create a shortcut button that will streamline these changes. To begin with - the assumption is that there is already text in the header/footer rolled forward from the prior year. I wish to press this button so that it applies the style change to the text already in the sheet. See attached file for formatting. Any help is appreciated. My current macro is setup to apply the font, but it changes the current text - this works well for new files, but not for files that have been rolled forward from prior years and simply need format adjustments.

    A second question is - if I want to create a toggle button, say to show gridlines on the file sheet, is there a simple way to do that?

    Again, thanks!

    Note margin adjustments too.

    Header left Font size 11:
    Company Name
    Month DD, YYYY

    XXX: MM/DD/YY


    Header Right Font size 11:
    Workpaper Name
    Page Number in work book
    [This cannot be static]

    Bottom left Font size 9:
    File: Filename [According to my macro code &9File: &F]

    Bottom right Font size 11:
    APX-XX
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 10-27-2011, 06:20 PM
  2. How to apply current sheet headers/footers to all other sheets?
    By ericsastud in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2011, 04:51 PM
  3. scaling font size in headers and footers
    By Folina in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2008, 12:16 PM
  4. Headers and footers
    By jollyg50 in forum Excel General
    Replies: 3
    Last Post: 07-17-2007, 06:24 PM
  5. How do I set the default font for headers and footers in Excel?
    By KC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2006, 03:25 PM
  6. [SOLVED] Font Colors with headers and Footers
    By sip8316 in forum Excel General
    Replies: 1
    Last Post: 06-17-2005, 08:05 PM
  7. Headers/Footers Default Font?
    By Ken in forum Excel General
    Replies: 0
    Last Post: 03-10-2005, 05:06 PM
  8. [SOLVED] Change the font size of the Column/Row headers?
    By Dave F. in forum Excel General
    Replies: 2
    Last Post: 01-28-2005, 02:06 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