LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
FJ FJ is offline
external usenet poster
 
Posts: 90
Default Change font size of header on every sheet?

Hi, I have several workbooks with over 50 worksheets. I have to change the
font size of the text in the headers to 14 points on every sheet. Is there a
quick way to do this with VBA? I tried doing it without VBA, by selecting
all the sheets at once and changing the font size, but of course this also
changed the text and made it the same as the text in the first sheet header.

Thanks in advance for any information.
 
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
I'm unable to change font size on a excell sheet Steve Excel Worksheet Functions 1 January 3rd 10 06:03 PM
How do I change the font size inside a sheet tab? rgranell Excel Worksheet Functions 2 December 16th 08 07:15 PM
How can I change the font size on an Excel sheet tab? Inobugs Excel Discussion (Misc queries) 3 October 26th 05 10:58 AM
Change font size on sheet tabs Gavin Excel Discussion (Misc queries) 1 June 13th 05 07:50 AM
Change Header Font Size Bret Excel Programming 2 October 27th 04 04:19 PM


All times are GMT +1. The time now is 01:48 AM.

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"