Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic Question
I have several worksheets that I need to inset the page
number into the center footer. I would use the &page number but my page numbers are in the format of "1-1, 1-2, 1-3, etc." Excel does not allow this so I am trying to write a macro that asks me the page number and inserts it into the center footer position. I have that part of the macro written but I cannot format the font, size and boldness of the page number. Can anyone give me a hand. Here is the macro I have currently tried and I want it to appear Arial Font size 4, and Bolded. Sub PageNumber() ActiveSheet.PageSetup.CenterFooter = InputBox("Enter page Number") End Sub Any ideas or suggestions would be greatly appreciated. Thanks in adance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual basic 6.5 question using combo box and call procedure. | Excel Discussion (Misc queries) | |||
Visual Basic Question | Excel Worksheet Functions | |||
visual basic coding question | Excel Discussion (Misc queries) | |||
Visual Basic Question | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) |