Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Footer in a Chart (2000)

    I am trying to put footer in several charts. I have written the footer:

    With ActiveChart.PageSetup
    .LeftFooter = ""
    .CenterFooter = "&""Times New Roman,Regular""&8&T &D. " & ActiveWorkbook.FullName & "" & Application.ActiveSheet.Name
    .RightFooter = ""
    End With

    However when I select the chart and go to Tools/Macro the only options shown are Record New Macro and Visual Basic Editor.

    Can anyone help?

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

    Re: Footer in a Chart (2000)

    Where did you write this code (i.e., if you view the code, what does the title bar say)?
    And what is its "header" (i.e. Sub ..., or Function ...)?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Footer in a Chart (2000)

    Hans

    The code is in Module 1 of the Workbook, and it is a Sub.

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

    Re: Footer in a Chart (2000)

    Does the Sub have arguments?

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Footer in a Chart (2000)

    No.

    If it makes the code easier I would be happy for the macro to put the footer in all charts in the active sheet in turn.

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

    Re: Footer in a Chart (2000)

    Let's back up a step. You stated "... Tools/Macro the only options shown are Record New Macro and Visual Basic Editor". Do you mean that there is no Macros... menu item? If so:
    - Select Tools | Customize...
    - Activate the Commands tab.
    - Select Tools in the Categories list on the left.
    - Select Macros... in theCommands list on the right.
    - Drag Macros... to the menu bar.
    - Hover the mouse pointer over the Tools menu until it drops down.
    - Hover the mouse pointer over the Macro submenu until it flies out.
    - Drop Macros... in the submenu.
    - Close the Customize window.

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Footer in a Chart (2000)

    Thank you Hans, it works like a charm.

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Footer in a Chart (2000)

    Oops I replied to my own post.

    Thank you Hans, it works like a charm.

Posting Permissions

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