Results 1 to 3 of 3
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Header / Footer Dialog (XL XP)

    I was trying to activate the header footer dialog via vba using (something like) the following <pre> Application.Dialogs(xlDialogPrinterSetup).Show</pre>

    but I don't know the xlDialog... key word.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Header / Footer Dialog (XL XP)

    Use Application.Dialogs(xlDialogPageSetup).Show to display the page setup dialog. From this, you can open the custom header/footer dialog.

  3. #3
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Header / Footer Dialog (XL XP)

    Thx Hans - I was hoping to go straight to the header / footer dialog and not via the pagesetup - oh well, guess I cannot do that.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •