| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofit custom header top margin to text size
I have written a macro to to enter 2 lines of text into a custom header.
This macro also allows the font size to be adjusted independently for each line of text i.e. font size of 20 on the first line and font size 14 on the second line. Is there a way to calculate the height of the 2 lines of text and then use this calculation to adjust the top margin so that the custom header is neither too small which would cut off some of the header or to large which would waste space? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| header margin | Excel Discussion (Misc queries) | |||
| Link margin size and document size to all sheets | Excel Discussion (Misc queries) | |||
| Internal margin for row height autofit | Excel Discussion (Misc queries) | |||
| Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel | |||
| header in right or left margin? | Excel Discussion (Misc queries) | |||
Hybrid Mode
