LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 247
Default Change font and/or font size in headers, footers and body via VBA

Greetings:

Having major formatting problems when trying to run my Windows based W/B's
on a Mac.
It appears that the only way I can resolve the problems is to change the
font sizes (and likely also the column width settings) on a per SHEET basis.
To do this effectively, I'm hoping there is a way that code could be used to
"read" existing font size, then decrease it by ONE point.
Once actual font size required is determined, the code would be adjusted to
do its required changes in one run thru.
Require (adjustable) changes to: Header, Footer and (active) Body of
worksheet.

In order to (hopefully) help expedite this problem, I'm changing all my
windows based masters to use only the Arial font group.

Any assistance in this matter would be greatly appreciated.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change colour of font in xls headers/footers masonrj1 Excel Discussion (Misc queries) 1 October 24th 09 04:09 PM
Excel-Default Font for Headers and Footers marcopolo Excel Discussion (Misc queries) 0 May 30th 08 02:39 AM
How do I set the default font for headers and footers in Excel? KC Excel Worksheet Functions 1 March 17th 06 07:19 PM
Font Colors with headers and Footers sip8316 Excel Discussion (Misc queries) 1 June 18th 05 12:40 AM
Headers/Footers Default Font? Ken Excel Discussion (Misc queries) 0 March 10th 05 09:01 PM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"