| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format header in page setup
On Tuesday, 12 March 2002 13:49:17 UTC, Martin Gregory wrote:
I would like to format the centre header with Aerial bold 14 similar to the right header and have tried many combinations - none of which work! The code I'm using is: With ActiveSheet.PageSetup .CenterHeader = Me.ContractName.Text & Chr(10) & "Cash Flow Forcast" .RightHeader = "&""Arial,Bold""&D" .RightFooter = Application.UserName .Orientation = xlLandscape .CenterHorizontally = True .CenterVertically = False End With What do I need to change in the code? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format header in page setup
Hi
This should be fine .RightHeader = "&""Arial,Normal""&14&D" Regards J@@ Le 26/01/2014 04:31, a écrit : On Tuesday, 12 March 2002 13:49:17 UTC, Martin Gregory wrote: I would like to format the centre header with Aerial bold 14 similar to the right header and have tried many combinations - none of which work! The code I'm using is: With ActiveSheet.PageSetup .CenterHeader = Me.ContractName.Text & Chr(10) & "Cash Flow Forcast" .RightHeader = "&""Arial,Bold""&D" .RightFooter = Application.UserName .Orientation = xlLandscape .CenterHorizontally = True .CenterVertically = False End With What do I need to change in the code? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format header in page setup
sorry
try this .CenterHeader = "&""Arial,Bold""&14" & Me.ContractName.Text & Chr(10) & "Cash Flow Forcast" J@@ Le 26/01/2014 04:31, a écrit : On Tuesday, 12 March 2002 13:49:17 UTC, Martin Gregory wrote: I would like to format the centre header with Aerial bold 14 similar to the right header and have tried many combinations - none of which work! The code I'm using is: With ActiveSheet.PageSetup .CenterHeader = Me.ContractName.Text & Chr(10) & "Cash Flow Forcast" .RightHeader = "&""Arial,Bold""&D" .RightFooter = Application.UserName .Orientation = xlLandscape .CenterHorizontally = True .CenterVertically = False End With What do I need to change in the code? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| page setup, header/footer | Excel Discussion (Misc queries) | |||
| How do I set a date formula in the page setup header to add 10 | Excel Discussion (Misc queries) | |||
| PAGE.SETUP header format query | Excel Programming | |||
| How do I setup a header in Excel that prints only on first page? | Excel Discussion (Misc queries) | |||
| how do you delete a header in Page Setup? | Excel Discussion (Misc queries) | |||
Linear Mode
