Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
page setup via code
A worksheet's page setup information is stored in the PageSetup
property of the worksheet object. See VBA Help for PageSetup for a list of the various properties. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "pepenacho" wrote in message ... Does anyone know where I can get some samples of code that will help me figure out how a particular worksheet's "page setup" is setup. One I'd like to be able to "re-print" it into code and then use it for other sheets rather than going through the process of doing it by hand. Right now I have a template sheet that a macro uses to copy the settings, but that feels like a crude method. I've looked a few things up and not much help from the "Excel VBA code" books - or I'm not looking at the right one. Thanks, pepenacho |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page layout - page setup - items disabled | Excel Discussion (Misc queries) | |||
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) | |||
HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
Under Page Setup the page option of Ledger - for Office XP | Excel Discussion (Misc queries) |