Macro to set different margins on different pages 
Author Message
 Macro to set different margins on different pages

Hello all,

I need to write a macro that sets the margins of the second page onwards to
a different width than the first page. Is this possible in a generic sense?
i.e. I need this macro to work on any document regardless of sections etc.

Much obliged,
TimmyG.



Sat, 11 Dec 2004 21:44:56 GMT  
 Macro to set different margins on different pages
You have to use sections breaks.  A section break is what
contains the page margin data.  So, if you want the first
page's margins to be different than the second page, they
must be separated by a section break.  

Quote:
>-----Original Message-----
>Hello all,

>I need to write a macro that sets the margins of the

second page onwards to
Quote:
>a different width than the first page. Is this possible
in a generic sense?
>i.e. I need this macro to work on any document regardless
of sections etc.

>Much obliged,
>TimmyG.

>.



Sun, 12 Dec 2004 10:39:29 GMT  
 Macro to set different margins on different pages
Yes, a macro can set this up easily.  Turn on the
recorder, change the margins, insert a section break and
then change the margins again.  That will give you the
basics to work with.  

Quote:
>-----Original Message-----
>You have to use sections breaks.  A section break is what
>contains the page margin data.  So, if you want the first
>page's margins to be different than the second page, they
>must be separated by a section break.  

>>-----Original Message-----
>>Hello all,

>>I need to write a macro that sets the margins of the
>second page onwards to
>>a different width than the first page. Is this possible
>in a generic sense?
>>i.e. I need this macro to work on any document
regardless
>of sections etc.

>>Much obliged,
>>TimmyG.

>>.

>.



Sun, 12 Dec 2004 11:39:24 GMT  
 Macro to set different margins on different pages
Hi TimmyG,

The usual way of doing this is to put an invisible (e.g.
all-white) rectangle in the header of the page(s) where you
want wider margins. If you go to http://groups.google.com/ and
search for
         "Auto-format new page using VBA" author:Coan
you'll find an article with the details.

On Tue, 25 Jun 2002 14:44:56 +0100, "TimmyG"

Quote:

>Hello all,

>I need to write a macro that sets the margins of the second page onwards to
>a different width than the first page. Is this possible in a generic sense?
>i.e. I need this macro to work on any document regardless of sections etc.

>Much obliged,
>TimmyG.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.



Sun, 12 Dec 2004 14:25:07 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Setting the Top Margin differently on different pages

2. Setting different tooltips for different TreeView nodes

3. how can i get different margins on different pages?

4. Print Margins different in Preview and Print

5. How to deal with printer margins/printable area for different printers

6. Launching a different database from a different db w/ vba

7. Different menu's for different users

8. Userform size on different PCs/different resolutions- yikes!

9. What are these DISCO files and Why are they Different in different Directories?- Long Post-

10. SQL select different results on different forms

11. VB - Different behavior on different machines

12. Different color to different lines in textbox

 

 
Powered by phpBB® Forum Software