| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pageheader size
Hi,
Is it possible to specify font size for PageHeader inside Macros? ActiveSheet.PageSetup.CenterHeader = "good afternoon" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pageheader size
You can do it manually, so turn on the macro recorder and do it manually.
Then turn off the macro recorder and look at the recorded code. -- Regards, Tom Ogilvy "ermeko" wrote in message ... Hi, Is it possible to specify font size for PageHeader inside Macros? ActiveSheet.PageSetup.CenterHeader = "good afternoon" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pageheader size
Hi Tom,
I tried but the size does not change. Maybe it is because the header text is written in macros. I have to write it in macros because it writes to different dates which change according to the data in worksheet. I just want something like this: ActiveSheet.PageSetup.CenterHeader.font.size = 16 Any sugestions? Thanks "Tom Ogilvy" wrote: You can do it manually, so turn on the macro recorder and do it manually. Then turn off the macro recorder and look at the recorded code. -- Regards, Tom Ogilvy "ermeko" wrote in message ... Hi, Is it possible to specify font size for PageHeader inside Macros? ActiveSheet.PageSetup.CenterHeader = "good afternoon" |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pageheader size
There is no font property for a CenterHeader. You have to embed the size in
the string. For example ActiveSheet.PageSetup _ .CenterHeader = "&""Arial,Bold""&14This is the Date: &D" This sets the font, makes it bold, size 14 -- Regards, Tom Ogilvy "ermeko" wrote in message ... Hi Tom, I tried but the size does not change. Maybe it is because the header text is written in macros. I have to write it in macros because it writes to different dates which change according to the data in worksheet. I just want something like this: ActiveSheet.PageSetup.CenterHeader.font.size = 16 Any sugestions? Thanks "Tom Ogilvy" wrote: You can do it manually, so turn on the macro recorder and do it manually. Then turn off the macro recorder and look at the recorded code. -- Regards, Tom Ogilvy "ermeko" wrote in message ... Hi, Is it possible to specify font size for PageHeader inside Macros? ActiveSheet.PageSetup.CenterHeader = "good afternoon" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom size (page size) missing in excel 2003 | Setting up and Configuration of Excel | |||
| Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
| My tabs' font size is smaller - how do I restore default size? | Excel Discussion (Misc queries) | |||
| Can we write VBA code to set all column/row's size back to default size? | Excel Programming | |||
| Can we write VBA code to set all column/row's size back to default size? | Excel Programming | |||
Linear Mode
