| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Page setup for multiple worksheet in a workbook
I have multiple (over 30) worksheets in a workbook. I need some VBA that
will go and set the following for all worksheets in the workbook: Font = Arial Font Style = Regular Font Size = 10 Left Margin = 1/2" Right Margin = 1/2" Top Margin = 1" Bottom Margin = 1" Footer = Blank Header = Sept Sales Orientation = Landscape Paper Size = Letter Can anyone help me automate this as I will have this issue every mont. It takes a lot of time to format each sheet manually. Thanks in advance for your help. Cheers. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE | Excel Discussion (Misc queries) | |||
| Page Setup when saving a worksheet as a web page | Excel Discussion (Misc queries) | |||
| changing the page setup for multiple worksheets in a workbook | Excel Discussion (Misc queries) | |||
| copy page setup from worksheet to another within workbook | Excel Worksheet Functions | |||
| protect format - page setup | Excel Discussion (Misc queries) | |||
Threaded Mode
