Posted to microsoft.public.excel.programming

external usenet poster

Posts: 6

Sorry forgot the vb code for the header!

'Create Header and Footer
headerText = "Preliminary Sales Forecast for " & drugName & "
and " & indicationName & "-" & sht.Name
sht.PageSetup.CenterHeader = headerText

dateNum = Format(Date, "mmmm d, yyyy")
sht.PageSetup.RightHeader = dateNum

Could someone help me make this font size 12 and also bold??

Thanks!
SV

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 forgot my password, how do I open a sheet if I forgot the pass	Hector Solorzano	Excel Worksheet Functions	4	February 20th 13 05:08 AM
Omit header from first page without embedding header in code	ibvalentine	Excel Worksheet Functions	6	August 28th 07 05:10 AM
Forgot the Code	Duncan_J	Excel Programming	1	February 2nd 06 10:01 PM
Header code	Bdavis[_2_]	Excel Programming	6	November 4th 04 05:07 AM
Header code	BDavis	Excel Programming	0	November 3rd 04 09:10 PM

All times are GMT +1. The time now is 02:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us